View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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