If A1 contains the start time then
=A1+5/24
will show the time 5 hours later


Just divide the extra hours by 24
--
Gary''s Student - gsnu200719


" wrote:

I'm trying to figure out a formula to correct add time to hours.

For example, we have a job starting at 6AM and it will run for 5
hours. I want to the formula to automatically calculate that the next
job will start at 11AM. Is there a formula for this?

Thanks,
SKA120