add duration to start time

[GeneWan]

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!

 

[Bob Phillips]

=start_time+2.8/24
--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[GeneWan]

thanks bob! I tried a few ways except this..

=start_time+2.8/24
--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

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!

 

[Bob Phillips]

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)

thanks bob! I tried a few ways except this..

=start_time+2.8/24
--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

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!