Absolute time value in reports

T

Troy

When summing a group with time values formatted in "short time", if the value
goes over 24 hours, it displays the time as it would be in the next day. For
example, if my total time was 25:42, it displays it as 1:42.

Does anyone know how to correct this without having to write extensive code
for the calculation?
 
M

Marshall Barton

Troy said:
When summing a group with time values formatted in "short time", if the value
goes over 24 hours, it displays the time as it would be in the next day. For
example, if my total time was 25:42, it displays it as 1:42.
Click to expand...


Int(time * 24) & Format(time,"\:nn")
 
Top