DATETIME() + NUMBER = DATETIME() ?

[amufaamo]

I want to make expression like 

End (datetime) = Start  (datetime) + Estimated Time (number)

For Example, I add Start = "2022/11/07 20:00:00", and I add Estimated Time = 30, End should be  "2022/11/07 20:30:00".

I made expression [Start] + [Estimated Time], but it didn't work. How can I write the expression?

[Suvrutt_Gurjar · Accepted solution]

[Estimated time] needs to be of duration column type and not number type. And in AppSheet duration is denoted by an extra leading 0  to the time component. Also adding simply 30 will not help as the expression needs to know if 30 are hours, minutes or seconds. so you need to put the duration in proper 0hh:mm:ss format.

So for estimated time of 30 minutes you need to add "000:30:00" so estimated column needs to  have "000:30:00"

[amufaamo]

Thank you so much. I understand it.

[Steve]

Date and time expressions - AppSheet Help