Calculating date/time intervals??

[jj]

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

 

[Ashish Mathur]

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