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

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

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

On Wed, 21 Mar 2007 05:13:00 -0700, Peter Rooney
wrote:

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

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

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" wrote:

On Wed, 21 Mar 2007 05:13:00 -0700, Peter Rooney
wrote:

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

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

On Wed, 21 Mar 2007 06:05:31 -0700, Peter Rooney
wrote:

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