 |
 | 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 / May 2008Calculating specific increments of time across days
I have dates & times which I need to enter (which is the easy part). However, I need to use the difference (in hours) to calculate the cost incurred when the hours fall between 0600 -1800 (day cost) and 1800-0600 (night cost). If the hours fall between day cost hours, then I want a specific cell to calculate the difference in hours in decimal form. If the hours fall between night hours, then I want the difference to calculate in another row. For example: A B C (day cost) D (night cost) 1 3/3/08 06:15 3/5/08 16:45 # hours # hours I don't know if this is possible, but if it is, it will save me tons of time. Right now I am manually inputting the increments to separate night and day cost hours and having excel calculate the rest. Thanks!  SignatureELG How are we supposed to know what hours were worked on March 4th? For what you want to do to work, I think you will need to enter each days work hours separately. Rick >I have dates & times which I need to enter (which is the easy part). > However, I need to use the difference (in hours) to calculate the cost [quoted text clipped - 14 lines] > and > day cost hours and having excel calculate the rest. Thanks! Sorry I wasn't very clear... This is a facility rate structure which I am looking at. It charges a customer for using a facility. So any dates in between the two dates, there is an assumption that 12 hours were day chrages and 12 hours were night charges for those days. So if a customer enters on 3/3/08 at 6:15 and then stays at the facility through 3/5/08 until 16:45, then I wish to calculate how many day and night hours there were between 3/3/08 6:15 and 3/5/08 6:45 as there is a charge for hours stayed between 0600 -1800 and a different rate for 1800-0600. SignatureELG > How are we supposed to know what hours were worked on March 4th? For what > you want to do to work, I think you will need to enter each days work hours [quoted text clipped - 20 lines] > > and > > day cost hours and having excel calculate the rest. Thanks! |
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.