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!

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!

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!

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!