View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Calculating date/time intervals??

Hi,

Assume that starting entry is in cell C7 and finishing entry is in cell C9

=INT(C9)-INT(C7) for days;
=(C9-C7)*24*60 for minutes; and
=(C9-C7)*24 for days

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jj" wrote in message
...
I have multiple sets of date/time value combinations. For each start time
(date/time) and finish time (date/time), I need a formula that calculates
the
number of days, hours, and minutes between the two events.

Example: Start 5/14/2010, 11:25 Finish 5/17/2010, 18:30

Thanks for any assistance!

John