Calculating the number of minutes between days
=(SUBSTITUTE(A1,".","")-SUBSTITUTE(A2,".",""))*1440
assuming A1 and A2 contain the 2 dates
If the dates have no decimal points around am and pm you could simply
subtract one from another and multiply the result by 1440
"Jennifer Duffer" wrote:
I need to calculate the number of minutes between two times on two different
days.
For example:
2/6/2008 12:35 p.m.
2/8/2008 4:17 a.m.
Any thoughts or direction I should go?
Thanks much in advance!
|