Absolute time value in reports

[Guest]

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?

 

[Marshall Barton]

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.

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