Start time in A1, end time in B1

=B1-A1+(B1<A1)

(format result as time)

or

=MOD(B1-A1,1)


will return 6:00 with 09:00 PM in A1 and 03:00 AM in B1


--
Regards,

Peo Sjoblom

"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?