Does anyone know how to subtract one time field (13:10:23 for example) from another? Is there a built in function in Excel or do I have to split the hour, minute and second into separate fields and then do the math?
Simply subtracting the two time values should result in a fractional number that represents the portion of 24hours that is the difference between the two.
For example:
A1 = 8:00 am
A2 = 5:30 pm
A3 = A1 - A2
A3 will be 0.395833333 (when you format it to General)
To determine the number of hours elapsed:
A4 = A3 * (24)
To determine the number of minutes elapsed:
A5 = A3 * (24 * 60)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.