Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculating date time ranges
I have a spreadsheet that I wish to calculate the number of hours between two
events. The first event has a date column and a time column (i.e. 11/9/04 0700) the second event also has a date column and a time column. I would like to calculate the number of hours difference between the two events. Example first event 11/01/04 0700 and second event 11/05/04 1100. Thanks for any help |
#2
|
|||
|
|||
Just do the difference of the dates. But make sure the resulting cell has the custom format "[hh]:mm" -- anilsolipuram ------------------------------------------------------------------------ anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271 View this thread: http://www.excelforum.com/showthread...hreadid=277245 |
#3
|
|||
|
|||
Assuming earlier date in A1, time in B1, 2nd (later) date in A2, 2nd time in
B2 =A2+B2-(A1+B1) On Wed, 10 Nov 2004 16:21:04 -0800, "Patrick" wrote: I have a spreadsheet that I wish to calculate the number of hours between two events. The first event has a date column and a time column (i.e. 11/9/04 0700) the second event also has a date column and a time column. I would like to calculate the number of hours difference between the two events. Example first event 11/01/04 0700 and second event 11/05/04 1100. Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |