Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
SUM-ing date for different time intervals | Excel Worksheet Functions | |||
calculating date intervals | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |