| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time HH:MM when it addds up to more than 24 hours | New Users to Excel | |||
| How can I change time format to decimal without losing hours? | Excel Discussion (Misc queries) | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
| Adding time in hours | Excel Discussion (Misc queries) | |||
| I need to measure hours between two events(time/date) to give me . | Excel Worksheet Functions | |||
Linear Mode
