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!