Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate time difference to the half hour | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions |