XL stores times as fractional days (so 03:00 = 0.125). Since times roll
over at midnight, you have to add 1 (a full day) to the later time if
your values times spand midnight. You can use the fact that XL coverts
boolean TRUE/FALSE values into 1/0, respectively, in math functions:

A1: start time
B1: end time
C1: =B1 - A1 + (B1<A1)

or the more obscure but equivalent

C1: =MOD(B1-A1, 1)

See

http://cpearson.com/excel/datetime.htm

for more





In article ,
"TMbender" wrote:

I working on a 2 week schedule for my employees. What i need to know is, how
do I calculate the time between 10:00 pm and 6:00 am in excel?