Absolute time value in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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")
 
Back
Top