Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? . |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
Is there any newsgroup where you didn't ask this question ?
Best wishes Harald |
#7
|
|||
|
|||
Yeah, a couple. ;-)
"Harald Staff" wrote: Is there any newsgroup where you didn't ask this question ? Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
adding hours and minutes | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |