Adding hours to a date
Hi,
I want to add a number of hours to a date and a time and have Excel give me the resulting date and time. The hours that I will want to add to the date could be anything, including part days, eg 3.25 hours, 92.4 hours, and so on. For instance 1st Dec 2004 13:00 Add 50.5 hours Result: 3rd Dec 2004 15:30 What is the formula that I need to achieve this? |
Since 1 = 1 full day in Excel, 3.25 hours would be
3.25/24. Example formula: =A1+3.25/24 HTH Jason Atlanta, GA -----Original Message----- Hi, I want to add a number of hours to a date and a time and have Excel give me the resulting date and time. The hours that I will want to add to the date could be anything, including part days, eg 3.25 hours, 92.4 hours, and so on. For instance 1st Dec 2004 13:00 Add 50.5 hours Result: 3rd Dec 2004 15:30 What is the formula that I need to achieve this? . |
Hi
Something like =A2+50.5/24 with date in A2 -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Rich" wrote in message ... Hi, I want to add a number of hours to a date and a time and have Excel give me the resulting date and time. The hours that I will want to add to the date could be anything, including part days, eg 3.25 hours, 92.4 hours, and so on. For instance 1st Dec 2004 13:00 Add 50.5 hours Result: 3rd Dec 2004 15:30 What is the formula that I need to achieve this? |
Is there any newsgroup where you didn't ask this question ?
Best wishes Harald |
Yeah, a couple. ;-)
"Harald Staff" wrote: Is there any newsgroup where you didn't ask this question ? Best wishes Harald |
Adding hours to a date
What would you do if the resulting time is greater than 5 pm, you want it to
add the hours to the following day starting at 8 am, and it skips weekend days? For example: 10/11/06 4:40 pm + 4 hours - 10/12/06 11:40 am. Thank you, Rachel "Jason Morin" wrote: Since 1 = 1 full day in Excel, 3.25 hours would be 3.25/24. Example formula: =A1+3.25/24 HTH Jason Atlanta, GA -----Original Message----- Hi, I want to add a number of hours to a date and a time and have Excel give me the resulting date and time. The hours that I will want to add to the date could be anything, including part days, eg 3.25 hours, 92.4 hours, and so on. For instance 1st Dec 2004 13:00 Add 50.5 hours Result: 3rd Dec 2004 15:30 What is the formula that I need to achieve this? . |
Adding hours to a date
Oh man! I meant
For example: 10/11/06 4:40 pm + 4 hours = 10/12/06 11:40 am. Sorry. "RFrechette" wrote: What would you do if the resulting time is greater than 5 pm, you want it to add the hours to the following day starting at 8 am, and it skips weekend days? For example: 10/11/06 4:40 pm + 4 hours - 10/12/06 11:40 am. Thank you, Rachel "Jason Morin" wrote: Since 1 = 1 full day in Excel, 3.25 hours would be 3.25/24. Example formula: =A1+3.25/24 HTH Jason Atlanta, GA -----Original Message----- Hi, I want to add a number of hours to a date and a time and have Excel give me the resulting date and time. The hours that I will want to add to the date could be anything, including part days, eg 3.25 hours, 92.4 hours, and so on. For instance 1st Dec 2004 13:00 Add 50.5 hours Result: 3rd Dec 2004 15:30 What is the formula that I need to achieve this? . |
All times are GMT +1. The time now is 01:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com