I have a spreadsheet with the time someone has been in an application expressed as 128:23:44 or 128 hours, 23 minutes and 44 seconds
Unfortunately Excel is reading it as a date and time 1/5/1900 8:23:44 AM
I can't seem to find the right format so Excel understands it is 128 hours, 23 minutes and 44 seconds and not a date and time.
Can someone help me with this?
Ultimately I would like to be able to accurately separate out the hours, minutes and second in separate columns which I can currently do but only if the total time is less than 24 hours. (=HOUR(A1)
Unfortunately Excel is reading it as a date and time 1/5/1900 8:23:44 AM
I can't seem to find the right format so Excel understands it is 128 hours, 23 minutes and 44 seconds and not a date and time.
Can someone help me with this?
Ultimately I would like to be able to accurately separate out the hours, minutes and second in separate columns which I can currently do but only if the total time is less than 24 hours. (=HOUR(A1)