Bug in dateAdd() formula

[Hossein]

Hello everyone,

As you can see in the attached photos, I have three columns:

• Start Time
• Planned Duration (POM)
• End Time

In the End Time column, I would like to add the Planned Duration (POM) to the Start Time in hour format. However, as shown in the End Time column, the hour and minute are not displayed.

I would be grateful if anyone could assist me with this issue.

Thank you.

[bennhatton]

Hi @Hossein, and welcome to the SeaTable forum!
Probably you should just edit the output format of your End Time column. For that:

• click the black downwards triangle on the right of the end time column header
• click Edit format settings
• select one of the four latest format which include both date and time

Bests,
Benjamin

[Hossein]

Thank you. It works. I have not seen that before.