| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add duration to start time
how can i do this? eg. I start a job at 8am, I needed 2.8 hours to complete
the job, how do I add the [2.8 hrs] to [8am] to obtain an expected completion time? completion hour can show either in 12 or 24 hours time format. thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add duration to start time
=start_time+2.8/24
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "GeneWan" wrote in message ... how can i do this? eg. I start a job at 8am, I needed 2.8 hours to complete the job, how do I add the [2.8 hrs] to [8am] to obtain an expected completion time? completion hour can show either in 12 or 24 hours time format. thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add duration to start time
thanks bob! I tried a few ways except this.. :)
"Bob Phillips" wrote: =start_time+2.8/24 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "GeneWan" wrote in message ... how can i do this? eg. I start a job at 8am, I needed 2.8 hours to complete the job, how do I add the [2.8 hrs] to [8am] to obtain an expected completion time? completion hour can show either in 12 or 24 hours time format. thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add duration to start time
The secret is knowing that Excel stores time as a fraction of a day, so you
just divide the number of hours by 24 to get it into time style/format (whatever the correct phraseology is). -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "GeneWan" wrote in message ... thanks bob! I tried a few ways except this.. :) "Bob Phillips" wrote: =start_time+2.8/24 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "GeneWan" wrote in message ... how can i do this? eg. I start a job at 8am, I needed 2.8 hours to complete the job, how do I add the [2.8 hrs] to [8am] to obtain an expected completion time? completion hour can show either in 12 or 24 hours time format. thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a duration time value and a clock time value? | Excel Worksheet Functions | |||
| Date/time Duration | Excel Worksheet Functions | |||
| Time duration formula | Excel Discussion (Misc queries) | |||
| Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
| How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. | Excel Worksheet Functions | |||
Linear Mode
