Calculating date/time intervals??

  • Follow


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
0
Reply Utf 5/28/2010 5:46:26 PM

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" <jj@discussions.microsoft.com> wrote in message 
news:8D6FB267-5B16-4DF6-9ED2-CEFA9D658B2C@microsoft.com...
> 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 

0
Reply Ashish 5/28/2010 11:24:10 PM

1 Replies
830 Views

(page loaded in 0.028 seconds)


Reply: