Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of time in hours or minutes
Date (Requested) Time (Requested) Date (Update) Time (Update)
1/9/2006 9:09:50 1/10/2006 13:04:22 1/4/2006 20:50:20 1/17/2006 11:32:00 1/10/2006 2:19:11 1/10/2006 9:29:09 1/16/2006 3:44:36 1/19/2006 17:46:24 I have the following data in an excel sheet in different columns, and i would like to subtract the Date & time of requested data from Data & Time of Updated data, with the anwser in hours or minutes. Can anyone help, i have over 1000 data points to calculate, and i can't do this by manually. Thanks, Charles D. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of time in hours or minutes
Hi Charles
Try =(C1+D1)-(A1+B1) Format the cell with the formula FormatCellsNumberCustom [h]:mm and this will allow it to deal with periods greater than 24 hours. Copy down as appropriate. -- Regards Roger Govier "Charles" wrote in message oups.com... Date (Requested) Time (Requested) Date (Update) Time (Update) 1/9/2006 9:09:50 1/10/2006 13:04:22 1/4/2006 20:50:20 1/17/2006 11:32:00 1/10/2006 2:19:11 1/10/2006 9:29:09 1/16/2006 3:44:36 1/19/2006 17:46:24 I have the following data in an excel sheet in different columns, and i would like to subtract the Date & time of requested data from Data & Time of Updated data, with the anwser in hours or minutes. Can anyone help, i have over 1000 data points to calculate, and i can't do this by manually. Thanks, Charles D. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of time in hours or minutes
Roger Govier wrote: Hi Charles Try =(C1+D1)-(A1+B1) Format the cell with the formula FormatCellsNumberCustom [h]:mm and this will allow it to deal with periods greater than 24 hours. Copy down as appropriate. -- Regards Roger Govier "Charles" wrote in message oups.com... Date (Requested) Time (Requested) Date (Update) Time (Update) 1/9/2006 9:09:50 1/10/2006 13:04:22 1/4/2006 20:50:20 1/17/2006 11:32:00 1/10/2006 2:19:11 1/10/2006 9:29:09 1/16/2006 3:44:36 1/19/2006 17:46:24 I have the following data in an excel sheet in different columns, and i would like to subtract the Date & time of requested data from Data & Time of Updated data, with the anwser in hours or minutes. Can anyone help, i have over 1000 data points to calculate, and i can't do this by manually. Thanks, Charles D. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
converting hours to minutes w/o VBA | Excel Worksheet Functions | |||
Subtract time between certain days/work hours? | Excel Worksheet Functions | |||
Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
Time - Hours and Minutes | Excel Discussion (Misc queries) |