Adding hours to time in Excel

[ska120]

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

 

[Guest]

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


Just divide the extra hours by 24

 

[Guest]

hi.
i'm korean microsoft OFFICE EXCEL MVP
THANKS A LOT.

I DON'T KNOW VERY WELL.

I THINK,

=A1+TIME(5,0,0)

 

[Peo Sjoblom]

Try that with 30 hours

 

[Guest]

Peo Sjoblom

HI,

HOW are you doing?

excel answer , WHAT DO YOU MEAN?

once more.

thanks a lot.

 

[Peo Sjoblom]

I am saying that your solution will not work if you add 30 hours

 

[Guest]

hi, Peo Sjoblom
EXCUSE ME BUT, SHOW SAMPLES.
THANKS A LOT.