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