elapsed time in hours:minutes like (125:13)

[#1]

Hi

I need to show time in the format h:mm where h however can be more than 24.

My calculation is sum(Endtime - Starttime)

I tried to format with time(sum(Endtime - Starttime), 'h:mm') but this shows me the hours as modula of 24. Also using 'hhhh:mm' results in leading zeros only with the truncated hours.

Any shortcut instead of a rather long formula to calculate and concat subresults?

Jürg

[Miguel_Angel_Baeyens · Accepted solution]

Hello Jürg,

interval() and interval#() should work for you:

interval('125:33', 'hhh:mm')

is now a valid timestamp you can add to any other date, for example

today() + interval('125:33', 'hhh:mm')

Something like

=interval(Num(today()-9) - Num(today()) , 'hhh:mm')

should work.

Hope this shed some light!

[#3]

Miguel

thanks a lot, does exactly what I was looking for

Jürg