Calculating specific increments of time across days

  • Thread starter Thread starter asynmyx
  • Start date Start date
A

asynmyx

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!
 
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
 
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.
 
Back
Top