 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006Adding 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, [quoted text clipped - 15 lines] > >. 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 > Since 1 = 1 full day in Excel, 3.25 hours would be > 3.25/24. Example formula: [quoted text clipped - 27 lines] > > > >. Oh man! I meant For example: 10/11/06 4:40 pm + 4 hours = 10/12/06 11:40 am. Sorry. > 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 [quoted text clipped - 37 lines] > > > > > >. Hi Something like =A2+50.5/24 with date in A2  SignatureArvi Laanemets (When sending e-mail, use address arvil<At>tarkon.ee) > Hi, > [quoted text clipped - 12 lines] > > 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. ;-) > Is there any newsgroup where you didn't ask this question ? > > Best wishes Harald |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.