How do you find the difference between two time values when one i.

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

Guest

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.
 
Hi

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

cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtracting date and time to find the difference between the two 4
difference in time 1
How to I subtract two dates & times to obtain a time 19
time calculation, 24:00 - 16:00 = 8 3
find the difference between start time and end time when spanning. 8
military time calculations 1
How do I add/subtract hours and minutes when some values exceed 2. 2
UDF To Calculate Work hours between two dates Problem with code 4

Back
Top