| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a decimal hours to a starting time to give a finishing tim | Excel Discussion (Misc queries) | |||
| Adding time HH:MM when it addds up to more than 24 hours | New Users to Excel | |||
| adding total number of hours in excel? | Excel Worksheet Functions | |||
| Adding time in hours | Excel Discussion (Misc queries) | |||
| How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
Linear Mode
