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

[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

 

[Ron Rosenfeld]

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

Time is stored as a fraction of a day.

So, for your problem:

=A1+B15/24

and format as TIME


--ron

 

[Guest]

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 Rosenfeld]

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

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