View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

one option format the result using the custom format of [h]:mm
(select cell, format / cells / number tab - custom)

cheers
JulieD

"tubroh730" wrote in message
...
When subtracting two time values, everything is OK as long as everthing is
less than 24 hours. I am trying to find how long students were using a
program and their user times are approaching values greater than 24 hours.
I
see that Excel loops back to 0 at 24 hours. Is there a solution? Thank
you.