![]() |
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. |
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