Bug in dateAdd() formula

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.

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

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

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.