time sheets giving a minus

D

dalenesa

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.
 
T

Tom

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

dalenesa

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!
 
Top