| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add hours to time
Travel 500miles (A1) 50 MPH (A2) 10 hrs travel time (A3)
Leave home at 6am (A4) - Using cell A3 (not 10 hrs), how do I calculate arrival time? (A5) Please include Cell Format, I can add the two but can't get passed 12:00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add hours to time
Hi,
Try: =A4+(A3/24) format as [h]:mm:ss HTH Jean-Guy "Danny C" wrote: Travel 500miles (A1) 50 MPH (A2) 10 hrs travel time (A3) Leave home at 6am (A4) - Using cell A3 (not 10 hrs), how do I calculate arrival time? (A5) Please include Cell Format, I can add the two but can't get passed 12:00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add hours to time
YUP, That worked, I've only spent about 3 hours on this. Formatting every
combination, that I could think of. THANK YOU! "pinmaster" wrote: Hi, Try: =A4+(A3/24) format as [h]:mm:ss HTH Jean-Guy "Danny C" wrote: Travel 500miles (A1) 50 MPH (A2) 10 hrs travel time (A3) Leave home at 6am (A4) - Using cell A3 (not 10 hrs), how do I calculate arrival time? (A5) Please include Cell Format, I can add the two but can't get passed 12:00 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add hours to time
You're welcome......glad I could help and thanks for the feedback.
Regards! Jean-Guy "Danny C" wrote: YUP, That worked, I've only spent about 3 hours on this. Formatting every combination, that I could think of. THANK YOU! "pinmaster" wrote: Hi, Try: =A4+(A3/24) format as [h]:mm:ss HTH Jean-Guy "Danny C" wrote: Travel 500miles (A1) 50 MPH (A2) 10 hrs travel time (A3) Leave home at 6am (A4) - Using cell A3 (not 10 hrs), how do I calculate arrival time? (A5) Please include Cell Format, I can add the two but can't get passed 12:00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Time sheets | Excel Worksheet Functions | |||
| Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
Linear Mode
