Either =B1-A1+(B1<A1) or =MOD(B1-A1,1)
--
David Biddulph

"dalenesa" wrote in message
...
I'm currently working on time sheets. I've got the times sorted out with
the
day shift, but the night shif times is still a problem. The guys works
from
17:00 to 06:00. That gives me 13 hours. Exel gives me the time worked
as -11
hours.

Can someone please help me, somewhere I must be doing something wrong.