As McGimpsey wrote, date is just a floating number from the base date
(1/1/1900).
Thus, if you use McGimpsey's formula and format it to number you will get
the number of minutes.

Alternative, just do B1-A1 and format it in Minutes (mm) which will only
work as long as the differnce is smaller then one hour.....

rdwj

"safetymast" wrote:

the problem i have is that the Date comes across in the same cell as the time
- how do i deal with that? thanks.

"JE McGimpsey" wrote:

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