ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you find the difference between two time values when one i. (https://www.excelbanter.com/excel-discussion-misc-queries/19236-how-do-you-find-difference-between-two-time-values-when-one-i.html)

tubroh730

How do you find the difference between two time values when one i.
 
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.

JulieD

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.





All times are GMT +1. The time now is 04:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com