Duration between two timestamps in hours, minutes, and seconds

[hlines_usacs]

Hello, I have two dates (timestamps) and I want to find the duration between the two in the format of hours, minutes, and seconds. For example: 4 hours, 6 minutes, 3 seconds.

Does anyone know how to do this?

Thanks!

[sunny_talwar]

May be use Interval() function

Interval(TimeStamp2 - TimeStamp1, 'hh:mm:ss')

[sunny_talwar · Accepted solution]

For the format, you can do this

=Replace(Replace(Replace(Interval(Now() - Today(), 'h@, mm#, ss$'), '@', ' hours'), '#', ' minutes'), '$', ' seconds')

[undergrinder]

Sunny is right, I can only append thatm you can format the string furhter with date function:

=date(interval(date2-date1','s'),'hh mm ss')