Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
abTech
Contributor III
Contributor III

Duration Calculation

Screenshot 2023-06-06 223300.png

 I have table that contains this tow columns i want to calculate the duration time in a new column the both column are timestamp data type 

Labels (1)
10 Replies
snibrahim1993
Partner - Contributor III
Partner - Contributor III

Try this @abTech 
Interval
( Timestamp#(EndDate, 'MM-DD-YY hh:mm TT') - Timestamp#(StartDate, 'MM-DD-YY hh:mm TT'), 'hh:mm' )

Regards, Mohamed Ibrahim.
If this resolves your Query please like and accept this as an answer.