*Sheet1
A1
H5
A1

I 3,
J 9,
K 11,
1 ,2
A1 ,B Time Tracker
A2 ,B Name
B2 ,B Time
C2 ,B Mon
D2 ,B Tue
E2 ,B Wed
F2 ,B Thu
G2 ,B Fri
H2 ,B Total Hrs
J2 ,B Real Time
K2 ,B Military Time
A3 , Ron
B3 , In
C3 ,F2E2T 8:15
J3 , 12:00 AM
K3 , 2400
B4 , Out
C4 ,F2E2T 16:00
J4 , 1:00  AM
K4 , 100
B5 , Total Hrs
C5 ,F2E2T =C4-C3
D5 ,F2E2T =D4-D3
E5 ,F2E2T =E4-E3
F5 ,F2E2T =F4-F3
G5 ,F2E2T =G4-G3
H5 , =sum(C5:G5)*24
J5 , 2:00 AM
K5 , 200
J6 , 3:00 AM
K6 , 300
A7 , Edward
B7 , In
C7 , 8:15
J7 , 4:00 AM
K7 , 400
B8 , Out
C8 , 17:00
J8 , 5:00 AM
K8 , 500
B9 , Total Hrs
C9 ,F2E2T =C8-C7
D9 ,F2E2T =D8-D7
E9 ,F2E2T =E8-E7
F9 ,F2E2T =F8-F7
G9 ,F2E2T =G8-G7
H9 , =sum(C9:G9)*24
J9 , 6:00 AM
K9 , 600
J10 , 7:00 AM
K10 , 700
A11 , Tim
B11 , In
C11 , 8:00
J11 , 8:00 AM
K11 , 800
B12 , Out
C12 , 16:00
J12 , 9:00 AM
K12 , 900
B13 , Total Hrs
C13 ,F2E2T =C12-C11
D13 ,F2E2T =D12-D11
E13 ,F2E2T =E12-E11
F13 ,F2E2T =F12-F11
G13 ,F2E2T =G12-G11
H13 , =sum(C13:G13)*24
J13 , 10:00 AM
K13 , 1000
J14 , 11:00 AM
K14 , 1100
J15 , 12:00 PM
K15 , 1200
J16 , 1:00 PM
K16 , 1300
J17 , 2:00 PM
K17 , 1400
J18 , 3:00 PM
K18 , 1500
J19 , 4:00 PM
K19 , 1600
J20 , 5:00 PM
K20 , 1700
J21 , 6:00 PM
K21 , 1800
J22 , 7:00 PM
K22 , 1900
J23 , 8:00 PM
K23 , 2000
J24 , 9:00 PM
K24 , 2100
J25 , 10:00 PM
K25 , 2200
J26 , 11:00 PM
K26 , 2300