Solved: Roundup To nearest hour - Page 2

BlakeHammond · 01-07-2021 02:45 PM

HI not sure If I being stupid.

I’m trying to round up duration to the nearest hour. In google sheets, I can do it with =ROUNDUP(C2/(1/24),0)*(1/24).

I just can’t figure out how to do it in Appsheet.

Suvrutt_Gurjar

I believe you may wish to share some more examples of desired results. Based on the example shared , you may wish to try the following

“000:00:00” + CEILING(TOTALHOURS([EndTime] - [StartTime]))

Your requirement is to calculate duration but just incase you are looking also for next hour time, @Steve had shared an excellent expression