View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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!