Thread: Calculate Minutes elapset between two cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Calculate Minutes elapset between two cells
=(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)


Reply With QuoteReply With Quote