P
Peter Rooney
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
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