Adding a decimal hours to a starting time to give a finishing tim

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon.

I'm currently looking at forecasting the length of time it will take to back
up different amounts of data. I have various answers (based on amounts of
data and network contention factors) which result in numbers which are
decimals of an hour e.g. 0.2 (which would equal 12 minutes), 0.5 (which would
equal 30 minutes) and so on.
I now need to add these to a defined start time which in my case is 06:00,
contained in , say A1 to give a finish time - for example, A1 containing
06:00 + B15 containing 0.2 hours (which equates to 12 minutes) would produce
a finish time of 06:12.

Can anyone help me with a nice formula or function?

Thanks in advance

Pete
 
Good afternoon.

I'm currently looking at forecasting the length of time it will take to back
up different amounts of data. I have various answers (based on amounts of
data and network contention factors) which result in numbers which are
decimals of an hour e.g. 0.2 (which would equal 12 minutes), 0.5 (which would
equal 30 minutes) and so on.
I now need to add these to a defined start time which in my case is 06:00,
contained in , say A1 to give a finish time - for example, A1 containing
06:00 + B15 containing 0.2 hours (which equates to 12 minutes) would produce
a finish time of 06:12.

Can anyone help me with a nice formula or function?

Thanks in advance

Pete
Click to expand...

Time is stored as a fraction of a day.

So, for your problem:

=A1+B15/24

and format as TIME


--ron
 
Ron,

That's what you get for being a project manager for 6 months - I'm woefully
out of practice!

Thank you VERY much!

Pete
 
Ron,

That's what you get for being a project manager for 6 months - I'm woefully
out of practice!

Thank you VERY much!

Pete
Click to expand...

You're welcome. Glad to help. Thanks for the feedback.
--ron
 
Back
Top