Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating 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! -- ELG |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating specific increments of time across days
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 "asynmyx" wrote in message ... 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! -- ELG |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating specific increments of time across days
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. -- ELG "Rick Rothstein (MVP - VB)" wrote: 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 "asynmyx" wrote in message ... 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! -- ELG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Calculating time from a specific paycheck period | Excel Worksheet Functions | |||
Calculating time increments from dates during working hours | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |