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.

Thanks

Change the formula in G4 to:
=E4+(H4/24)

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.

Here's another formula.

=TIME(HOUR(E4)+H4,0,0)

Steve,

Thank you very much. That helps greatly.

Have a great day.

Norie,

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.

You're welcome!