| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating time
Hi,
given a departure and arrival date and time, how to calculate the travel time (in hours) A B C D From To 10-Oct 00:05 12-Oct 14:13 Cell E should give the total amount of hours. Many thanks! tom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating time
Subtract the earlier from the later and format the result cell as [h]:mm or
just [h] -- --- HTH Bob (change the xxxx to gmail if mailing direct) "tom ossieur" wrote in message ... Hi, given a departure and arrival date and time, how to calculate the travel time (in hours) A B C D From To 10-Oct 00:05 12-Oct 14:13 Cell E should give the total amount of hours. Many thanks! tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating time
Problem is that date and time are in different columns
"Bob Phillips" wrote: Subtract the earlier from the later and format the result cell as [h]:mm or just [h] -- --- HTH Bob (change the xxxx to gmail if mailing direct) "tom ossieur" wrote in message ... Hi, given a departure and arrival date and time, how to calculate the travel time (in hours) A B C D From To 10-Oct 00:05 12-Oct 14:13 Cell E should give the total amount of hours. Many thanks! tom |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating time
So what
=B2-A2 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "tom ossieur" wrote in message ... Problem is that date and time are in different columns "Bob Phillips" wrote: Subtract the earlier from the later and format the result cell as [h]:mm or just [h] -- --- HTH Bob (change the xxxx to gmail if mailing direct) "tom ossieur" wrote in message ... Hi, given a departure and arrival date and time, how to calculate the travel time (in hours) A B C D From To 10-Oct 00:05 12-Oct 14:13 Cell E should give the total amount of hours. Many thanks! tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time increments from dates during working hours | Excel Worksheet Functions | |||
| calculating time | Excel Discussion (Misc queries) | |||
| help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
| Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
| Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Hybrid Mode
