Sample Pay Roll Data
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
NameIN/OUTDATETIME IN/OUT
2
Jimmy DeBlasioOut10/14/201419:30
3
Employee 14Out10/14/201418:00
4
Employee 15Out10/14/201418:00
5
Employee 14Out10/14/201418:00
6
Employee 13Out10/14/201418:00ArrayFormula(query({query({$A2:$A,$B2:$C,N($C2:$C+$D2:$D)},"select* where Col2='Out' and Col1<>'' and Col3>= date '"&text(G12,"yyyy-mm-dd")&"' and Col3<= date '"&Text(G13,"yyyy-mm-dd")&"' order by Col1,Col4,Col2 "),query({$A2:$A, $B2:$C,N($C2:$C+$D2:$D)},"select* where Col2='In' and Col1<>'' and Col3>= date '"&text( G12,"yyyy-mm-dd")&"' and Col3<= date '"&Text(G13,"yyyy-mm-dd")&"' order by Col1,Col4,Col2")}, "select Col1,(sum(Col4)-sum(Col8))*24 where Col1<>'' group by Col1 label (sum(Col4)-sum(Col8))*24 '' "))
7
Employee 14Out10/14/201417:30Jimmy DeBlasioOut10/14/201441926.8125
Jimmy DeBlasio
In10/14/201441926.55208Employee 14Out10/14/2014Employee 13
8
Employee 5Out10/14/201417:15Employee 14Out10/14/201441926.75Employee 17In10/14/201441926.38542Employee 15Out10/14/2014Employee 14
9
Employee 1Out10/14/201417:00Employee 15Out10/14/201441926.75Employee 2In10/14/201441926.375Employee 14Out10/14/2014Employee 5
10
Employee 2Out10/14/201417:00Employee 14Out10/14/201441926.75Employee 1In10/14/201441926.33333Employee 13Out10/14/2014Employee 1
11
Employee 6Out10/14/201416:00Employee 13Out10/14/201441926.75Employee 3In10/14/201441926.33333
12
Employee 8Out10/14/201416:00Employee 14Out10/14/201441926.72917Employee 4In10/14/201441926.3125
13
Employee 7Out10/14/201416:00Employee 5Out10/14/201441926.71875Employee 5In10/14/201441926.3125
14
Employee 3Out10/14/201416:00Employee 1Out10/14/201441926.70833Employee 6In10/14/201441926.29167
15
Employee 11Out10/14/201416:00Employee 2Out10/14/201441926.70833Employee 7In10/14/201441926.29167
16
Employee 9Out10/14/201416:00Employee 6Out10/14/201441926.66667Employee 10In10/14/201441926.29167
17
Employee 17Out10/14/201415:00Employee 8Out10/14/201441926.66667Employee 11In10/14/201441926.29167
18
Employee 10Out10/14/201415:00Employee 7Out10/14/201441926.66667Employee 9In10/14/201441926.29167
19
Jimmy DeBlasioIn10/14/201413:15Employee 3Out10/14/201441926.66667Employee 15In10/14/201441926.25
20
Employee 17In10/14/20149:15Employee 11Out10/14/201441926.66667Employee 8In10/14/201441926.25
21
Employee 2In10/14/20149:00Employee 9Out10/14/201441926.66667Employee 13In10/14/201441926.25
22
Employee 1In10/14/20148:00Employee 17Out10/14/201441926.625Employee 12In10/14/201441926.25
23
Employee 3In10/14/20148:00Employee 10Out10/14/201441926.625Employee 14In10/14/201441926.25
24
Employee 4In10/14/20147:30Employee 16Out10/13/201441925.82292Employee 16In10/13/201441925.54167
25
Employee 5In10/14/20147:30Employee 8Out10/13/201441925.76042Employee 17In10/13/201441925.38542
26
Employee 6In10/14/20147:00Employee 14Out10/13/201441925.75Employee 2In10/13/201441925.375
27
Employee 7In10/14/20147:00Employee 15Out10/13/201441925.73958Employee 1In10/13/201441925.35417
28
Employee 10In10/14/20147:00Employee 5Out10/13/201441925.71875Employee 5In10/13/201441925.32292
29
Employee 11In10/14/20147:00Employee 4Out10/13/201441925.71875Employee 4In10/13/201441925.3125
30
Employee 9In10/14/20147:00Employee 7Out10/13/201441925.70833Employee 6In10/13/201441925.30208
31
Employee 15In10/14/20146:00Employee 6Out10/13/201441925.70833Employee 7In10/13/201441925.30208
32
Employee 8In10/14/20146:00Employee 10Out10/13/201441925.70833Employee 9In10/13/201441925.29167
33
Employee 13In10/14/20146:00Employee 2Out10/13/201441925.70833Employee 10In10/13/201441925.29167
34
Employee 12In10/14/20146:00Employee 1Out10/13/201441925.6875Employee 3In10/13/201441925.29167
35
Employee 14In10/14/20146:00Employee 13Out10/13/201441925.66667Employee 11In10/13/201441925.29167
36
Employee 16Out10/13/201419:45Employee 12Out10/13/201441925.66667Employee 8In10/13/201441925.29167
37
Employee 8Out10/13/201418:15Employee 3Out10/13/201441925.625Employee 15In10/13/201441925.26042
38
Employee 14Out10/13/201418:00Employee 11Out10/13/201441925.625Employee 14In10/13/201441925.25
39
Employee 15Out10/13/201417:45Employee 9Out10/13/201441925.625Employee 13In10/13/201441925.25
40
Employee 5Out10/13/201417:15Employee 17Out10/13/201441925.625Employee 12In10/13/201441925.25
41
Employee 4Out10/13/201417:15Employee 8Out10/11/201441923.58333Employee 6In10/11/201441923.29167
42
Employee 7Out10/13/201417:00Employee 11Out10/11/201441923.58333Employee 7In10/11/201441923.29167
43
Employee 6Out10/13/201417:00Employee 7Out10/11/201441923.5625Employee 17In10/11/201441923.29167
44
Employee 10Out10/13/201417:00Employee 6Out10/11/201441923.5625Employee 3In10/11/201441923.29167
45
Employee 2Out10/13/201417:00Employee 9Out10/11/201441923.54167Employee 8In10/11/201441923.29167
46
Employee 1Out10/13/201416:30Employee 15Out10/11/201441923.5Employee 10In10/11/201441923.29167
47
Employee 13Out10/13/201416:00Employee 14Out10/11/201441923.5Employee 11In10/11/201441923.29167
48
Employee 12Out10/13/201416:00Employee 3Out10/11/201441923.5Employee 9In10/11/201441923.29167
49
Employee 3Out10/13/201415:00Employee 17Out10/11/201441923.47917Employee 15In10/11/201441923.21875
50
Employee 11Out10/13/201415:00Employee 10Out10/11/201441923.45833Employee 14In10/11/201441923.21875
51
Employee 9Out10/13/201415:00Employee 8Out10/10/201441922.71875
52
Employee 17Out10/13/201415:00Employee 5Out10/10/201441922.70833
53
Employee 16In10/13/201413:00Employee 13Out10/10/201441922.70833
54
Employee 17In10/13/20149:15Employee 7Out10/10/201441922.70833
55
Employee 2In10/13/20149:00Employee 6Out10/10/201441922.70833
56
Employee 1In10/13/20148:30Employee 14Out10/10/201441922.70833
57
Employee 5In10/13/20147:45Employee 11Out10/10/201441922.70833
58
Employee 4In10/13/20147:30Employee 15Out10/10/201441922.70833
59
Employee 6In10/13/20147:15Employee 3Out10/10/201441922.70833
60
Employee 7In10/13/20147:15Employee 2Out10/10/201441922.69792
61
Employee 9In10/13/20147:00Employee 1Out10/10/201441922.6875
62
Employee 10In10/13/20147:00
63
Employee 3In10/13/20147:00
64
Employee 11In10/13/20147:00
65
Employee 8In10/13/20147:00
66
Employee 15In10/13/20146:15
67
Employee 14In10/13/20146:00
68
Employee 13In10/13/20146:00
69
Employee 12In10/13/20146:00
70
Employee 8Out10/11/201414:00
71
Employee 11Out10/11/201414:00
72
Employee 7Out10/11/201413:30
73
Employee 6Out10/11/201413:30
74
Employee 9Out10/11/201413:00
75
Employee 15Out10/11/201412:00
76
Employee 14Out10/11/201412:00
77
Employee 3Out10/11/201412:00
78
Employee 17Out10/11/201411:30
79
Employee 10Out10/11/201411:00
80
Employee 6In10/11/20147:00
81
Employee 7In10/11/20147:00
82
Employee 17In10/11/20147:00
83
Employee 3In10/11/20147:00
84
Employee 8In10/11/20147:00
85
Employee 10In10/11/20147:00
86
Employee 11In10/11/20147:00
87
Employee 9In10/11/20147:00
88
Employee 15In10/11/20145:15
89
Employee 14In10/11/20145:15
90
Employee 8Out10/10/201417:15
91
Employee 5Out10/10/201417:00
92
Employee 13Out10/10/201417:00
93
Employee 7Out10/10/201417:00
94
Employee 6Out10/10/201417:00
95
Employee 14Out10/10/201417:00
96
Employee 11Out10/10/201417:00
97
Employee 15Out10/10/201417:00
98
Employee 3Out10/10/201417:00
99
Employee 2Out10/10/201416:45
100
Employee 1Out10/10/201416:30
Loading...
 
 
 
Copy of Copy of Sheet1 1
Sheet1
Copy of Sheet1 1
Copy of Sheet1
sheetJP