Calculate Minutes elapset between two cells
I was having trouble getting the functions reslult to display properly but
when I formulated it as a "general" type cell it works perfect.
Thanks again.
"David Biddulph" wrote:
=(A2-A1)*24*60 but the answer is 46080, not 1440. The dates are 32 days
apart, not 1 day.
--
David Biddulph
"bazsil,73" wrote in message
...
Lookikng for an easy way to calculate the minutes elapsed between two
cells.
The minutes will elapse over different days.
A1 = 7/7/2009 7:00:00 AM
A2 = 8/8/2009 7:00:00 AM
A3 = (the function I need) (should be 1440)
|