If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating date/time intervals??
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|