On Thursday, July 17, 2014 2:47:28 AM UTC-7, L. Howard wrote:
Typo



Column F is IN

Column H is OUT



H


Okay, fixed it by starting in row 2 instead if 1.

I get values like this in N, where the 0 is a employee not signed in. I don't understand the negative values???

What format would I use for column N to convert to hours + 10th's?

-41836.9135
0
0.041956019
0
0.041967593
0
-41836.93432
0
0.02650463


Howars