Prev: Final Reminder - Microsoft Responds to the Evolution of Community
Next: how to compare the old code and new code?
From: jj on 28 May 2010 13:46
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
From: Ashish Mathur on 28 May 2010 19:24
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(a)discussions.microsoft.com> wrote in message
news:8D6FB267-5B16-4DF6-9ED2-CEFA9D658B2C(a)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

 | 
Pages: 1
Prev: Final Reminder - Microsoft Responds to the Evolution of Community
Next: how to compare the old code and new code?