Aug 23 2007, 11:04 AM
I have spreadsheet the the user's click a button a form opens and they enter the data.
After they append the data to the spreadsheet I am trying to calculate times
For example: 13:00 + 6 (Hours to sort) Estimated time to finish = 19:00
It keeps coming up with the Start time of 13:00
Please see spreadsheet.
Aug 23 2007, 12:09 PM
Change the formula in G4 to:
It's treating your hours to add as days, so you should divide by 24. This is because Excel stores dates as numbers. See this page
for some background on how Excel works with date/time values.
Aug 23 2007, 12:21 PM
Here's another formula.
Aug 23 2007, 12:22 PM
Thank you very much. That helps greatly.
Have a great day.
Aug 23 2007, 12:25 PM
Thank you as well. I think Steve's formula will work better for me as it calulates down to minutes which is what I was looking for.
To much info is always good for reference.
Aug 23 2007, 02:01 PM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here