Adding hours to time in Excel
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 |
Adding hours to time in Excel
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 |
Adding hours to time in Excel
hi.
i'm korean microsoft OFFICE EXCEL MVP THANKS A LOT. I DON'T KNOW VERY WELL. I THINK, =A1+TIME(5,0,0) "Gary''s Student" wrote: 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 |
Adding hours to time in Excel
Try that with 30 hours
-- Regards, Peo Sjoblom "???" wrote in message ... hi. i'm korean microsoft OFFICE EXCEL MVP THANKS A LOT. I DON'T KNOW VERY WELL. I THINK, =A1+TIME(5,0,0) "Gary''s Student" wrote: 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 |
Adding hours to time in Excel
Peo Sjoblom
HI, HOW are you doing? excel answer , WHAT DO YOU MEAN? once more. thanks a lot. "Peo Sjoblom" wrote: Try that with 30 hours -- Regards, Peo Sjoblom "???" wrote in message ... hi. i'm korean microsoft OFFICE EXCEL MVP THANKS A LOT. I DON'T KNOW VERY WELL. I THINK, =A1+TIME(5,0,0) "Gary''s Student" wrote: 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 |
Adding hours to time in Excel
I am saying that your solution will not work if you add 30 hours
-- Regards, Peo Sjoblom "???" wrote in message ... Peo Sjoblom HI, HOW are you doing? excel answer , WHAT DO YOU MEAN? once more. thanks a lot. "Peo Sjoblom" wrote: Try that with 30 hours -- Regards, Peo Sjoblom "???" wrote in message ... hi. i'm korean microsoft OFFICE EXCEL MVP THANKS A LOT. I DON'T KNOW VERY WELL. I THINK, =A1+TIME(5,0,0) "Gary''s Student" wrote: 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 |
Adding hours to time in Excel
hi, Peo Sjoblom
EXCUSE ME BUT, SHOW SAMPLES. THANKS A LOT. "Peo Sjoblom" wrote: I am saying that your solution will not work if you add 30 hours -- Regards, Peo Sjoblom "???" wrote in message ... Peo Sjoblom HI, HOW are you doing? excel answer , WHAT DO YOU MEAN? once more. thanks a lot. "Peo Sjoblom" wrote: Try that with 30 hours -- Regards, Peo Sjoblom "???" wrote in message ... hi. i'm korean microsoft OFFICE EXCEL MVP THANKS A LOT. I DON'T KNOW VERY WELL. I THINK, =A1+TIME(5,0,0) "Gary''s Student" wrote: 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 |
All times are GMT +1. The time now is 02:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com