MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time Formula

Posted by Paul Magruder on March 08, 2001 11:56 AM

Is there a formula or code that will give me the amount of minutes between 2 time frames?
Example: a "=now" formula returns 14:30, another "=now" returns 14:34. I need a formula that will allow me to subtract one from the other and return 4 min.
I tried to convert the time into numbers, and then do the subtraction, but the return is 00:04( 4 min after midnight)I just meed the amount of minutes inbtween the time frames.
Thanks in advance Paul Magruder

Posted by Mark W. on March 08, 2001 12:32 PM

Paul, if you format, the cell containing the
difference of your times (e.g., ="14:34-"14:30")
as [m] it will display the elapsed time in minutes.
Internally, this elapsed time is stored as a
fraction of a 24-hr day. In the case of 4
elapsed minutes that value would be 0.002778. If
you need this value converted to minutes you'd
use the formula, =0.002778*24*60.