Calculating specific increments of time across days

[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!

 

[Rick Rothstein \(MVP - VB\)]

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]

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.