Assuming that your times are XL times like 21:00 and 3:00 and Start time in
B2, End time in C2 then try:

=MOD(C2-B2,1)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"mailrail" wrote in message
...
I'm trying to write a formula that will calculate my employees' total time
worked. A problem arises when I have people scheduled to work past
midnight.
If, say, someone works from 9 pm until 3 am, how do I get Excel to
recognize
the change in dates and properly figure the time?