I have a variable which calculates the difference between two date/times. I need to display it in the format of hh:mm. The issue is that when the difference is greater than 24 hours, it is not displaying properly. In excel, this is solved by applying the formatting context of [h]:mm. When I output t…

Display time duratoin in hours over 24

system May 17, 2009, 3:50pm 2

Hi,

Let us know what is the desired format of the variable when it exceeds 24 hours.

And have a look also here, it may help:

Marek Chladny (BOB member since 2003-11-27)