Count minutes between two time/date fields
Dates and times in XL are just floating point number offsets from a base
date, with the integer part representing days, and the fractional part
"partial days". There are 1440 minutes in a day, so
C1: =ROUND((B1-A1)*1440, 0)
will give you the number of minutes.
In article ,
safetymast wrote:
Does anyone have a formula they can give me to count the minutes between the
two columns below?
Dec.19.2007 21:36:23 Dec.19.2007 21:41:07
|