time sheets giving a minus
 

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.

time sheets giving a minus
 

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.

time sheets giving a minus
 

Make sure your dates are correct. From 17:00 to 06:00 is -11 hours, if
they're both on the same day.

"dalenesa" wrote:

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.

time sheets giving a minus
 

Thanks for your help guys, it works!!! So simple and yet such a headace if
you don't know how...

Thanks again and keep up the great work!

"dalenesa" wrote:

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.