Total: Date Day A.Time D.Time Total Time Over Time Less Time

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 14

NAME

Duty Hrs Salary


Month
Mob No.
Days
JAYDEEP
10:00
3000
JUNE
###
26
Date
Day
A.Time
D.Time
Total Time Over Time Less Time
6/1/2011 Wednesday 10:30 AM
9:00 PM
10:30
00:30
00:00
6/2/2011 Thursday
10:00 AM 10:00 AM
0:00
00:00
10:00
6/3/2011 Friday
10:00 AM 10:00 AM
0:00
00:00
10:00
6/4/2011 Saturday
10:00 AM 10:00 AM
0:00
00:00
10:00
6/5/2011 Sunday
10:00 AM 10:00 AM
0:00
00:00
00:00
6/6/2011 Monday
10:30 AM
8:45 PM
10:15
23:44
00:00
6/7/2011 Tuesday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/8/2011 Wednesday 12:00 PM
8:30 PM
0:00
00:00
22:29
6/9/2011 Thursday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/10/2011 Friday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/11/2011 Saturday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/12/2011 Sunday
1:59 PM
1:59 PM
0:00
00:00
00:00
6/13/2011 Monday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/14/2011 Tuesday
1:59 PM
1:59 PM
0:00
00:00
10:00
6/15/2011 Wednesday 10:30 AM
9:30 PM
11:00
22:59
00:00
6/16/2011 Thursday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/17/2011 Friday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/18/2011 Saturday
10:30 AM
3:00 PM
4:30
00:00
05:30
6/19/2011 Sunday
1:59 PM
1:59 PM
0:00
00:00
00:00
6/20/2011 Monday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/21/2011 Tuesday
10:30 AM
8:00 PM
9:30
00:00
00:30
6/22/2011 Wednesday 10:30 AM
9:15 PM
10:45
00:45
00:00
6/23/2011 Thursday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/24/2011 Friday
10:30 AM
9:00 PM
10:30
00:30
00:00
6/25/2011 Saturday
10:30 AM
9:00 PM
10:30
00:30
00:00
6/26/2011 Sunday
1:59 PM
1:59 PM
0:00
00:00
00:00
6/27/2011 Monday
10:30 AM
9:00 PM
10:30
00:30
00:00
6/28/2011 Tuesday
10:30 AM
8:30 PM
10:00
00:00
23:59
6/29/2011 Wednesday 10:30 AM 11:00 PM
12:30
21:29
00:00
6/30/2011 Thursday
1:59 PM
1:59 PM
0:00
00:00
10:00
TOTAL
Salary
3000

O.T.P.
-10.10

L.T.P
628.42

200:30

TOTAL

-1:00

54:27

2361.48

ADVANCE
Date

ADVANCE

ABSENT
HOLIDAY
T SALARY

A.TOTAL (-)
ADDL (+)
REM

PAID

0
2361.48

NAME
GAPPU
Date
Day
6/1/2011 Wednesday
6/2/2011 Thursday
6/3/2011 Friday
6/4/2011 Saturday
6/5/2011 Sunday
6/6/2011 Monday
6/7/2011 Tuesday
6/8/2011 Wednesday
6/9/2011 Thursday
6/10/2011 Friday
6/11/2011 Saturday
6/12/2011 Sunday
6/13/2011 Monday
6/14/2011 Tuesday
6/15/2011 Wednesday
6/16/2011 Thursday
6/17/2011 Friday
6/18/2011 Saturday
6/19/2011 Sunday
6/20/2011 Monday
6/21/2011 Tuesday
6/22/2011 Wednesday
6/23/2011 Thursday
6/24/2011 Friday
6/25/2011 Saturday
6/26/2011 Sunday
6/27/2011 Monday
6/28/2011 Tuesday
6/29/2011 Wednesday
6/30/2011 Thursday

Duty Hrs Salary


Month
Mob No.
10:00
3500
JUNE
A.Time
D.Time
Total Time Over Time
10:30 AM
3:30 PM
5:00
00:00
10:00 AM 10:00 AM
0:00
00:00
10:45 AM
9:00 PM
10:15
0:15
10:45 AM
9:00 PM
10:15
0:15
10:00 AM 10:00 AM
0:00
00:00
11:00 AM
8:45 PM
14:14
00:00
11:00 AM
9:00 PM
10:00
0:00
10:30 AM
8:30 PM
10:00
00:00
10:30 AM
8:30 PM
10:00
00:00
10:30 AM
8:30 PM
10:00
00:00
10:30 AM
8:30 PM
10:00
00:00
1:59 PM
1:59 PM
0:00
00:00
10:45 AM
8:30 PM
9:45
00:00
11:00 AM
8:30 PM
9:30
00:00
11:15 AM
9:30 PM
10:15
23:44
11:30 AM
8:30 PM
9:00
00:00
11:00 AM
8:30 PM
9:30
00:00
11:00 AM
9:00 PM
10:00
0:00
1:59 PM
1:59 PM
0:00
00:00
11:00 AM
8:30 PM
9:30
00:00
11:00 AM
8:00 PM
14:59
00:00
10:45 AM
9:15 PM
10:30
0:30
11:00 AM
8:30 PM
9:30
00:00
11:00 AM
8:30 PM
9:30
00:00
11:00 AM
8:30 PM
9:30
00:00
1:59 PM
1:59 PM
0:00
00:00
1:59 PM
1:59 PM
0:00
00:00
1:59 PM
1:59 PM
0:00
00:00
1:59 PM
1:59 PM
0:00
00:00
1:59 PM
1:59 PM
0:00
00:00
TOTAL

Salary
3500

O.T.P.
0.15

L.T.P
727.44

163:14

TOTAL

0:44

2772.71

Days

ADVANCE

25
Less Time
05:00
10:00
00:00
00:00
00:00
00:15
00:00
23:59
23:59
23:59
23:59
00:00
23:44
23:29
00:00
22:59
23:29
00:00
00:00
23:29
01:00
00:00
23:29
23:29
23:29
00:00
10:00
10:00
10:00
10:00

Date

51:57 TOTAL (-)


ADDL (+)
REM

2772.71

PAID

ADVANCE

0
2772.71

NAME
RAMLAL
Date
Day
6/1/2011 Wednesday
6/2/2011 Thursday
6/3/2011 Friday
6/4/2011 Saturday
6/5/2011 Sunday
6/6/2011 Monday
6/7/2011 Tuesday
6/8/2011 Wednesday
6/9/2011 Thursday
6/10/2011 Friday
6/11/2011 Saturday
6/12/2011 Sunday
6/13/2011 Monday
6/14/2011 Tuesday
6/15/2011 Wednesday
6/16/2011 Thursday
6/17/2011 Friday
6/18/2011 Saturday
6/19/2011 Sunday
6/20/2011 Monday
6/21/2011 Tuesday
6/22/2011 Wednesday
6/23/2011 Thursday
6/24/2011 Friday
6/25/2011 Saturday
6/26/2011 Sunday
6/27/2011 Monday
6/28/2011 Tuesday
6/29/2011 Wednesday
6/30/2011 Thursday

Duty Hrs Salary


Month
Mob No.
8:00
3800
JUNE
8120252711
A.Time
D.Time
Total Time Over Time
10:00 AM
8:45 PM
10:45
2:45
10:00 AM
8:45 PM
10:45
2:45
10:00 AM
9:00 PM
11:00
3:00
10:00 AM
8:20 PM
10:20
2:20
10:00 AM 10:00 AM
0:00
00:00
10:00 AM
8:30 PM
10:30
2:30
11:00 AM
8:00 PM
14:59
22:59
11:15 AM
8:00 PM
15:14
23:14
1:59 PM
8:00 PM
10:00
2:00
10:00 AM
8:00 PM
10:00
21:59
10:00 AM
4:19 AM
14:19
22:19
1:59 PM
1:59 PM
0:00
00:00
10:00 AM
8:30 PM
10:30
2:30
10:00 AM
8:30 PM
10:30
2:30
10:00 AM
7:30 PM
9:30
1:30
10:10 AM
8:20 PM
10:10
21:49
10:00 AM
8:45 PM
10:45
21:14
10:00 AM
8:00 PM
10:00
21:59
1:59 PM 10:00 AM
0:00
00:00
1:59 PM
7:30 PM
9:30
1:30
1:59 PM
8:00 PM
10:00
2:00
1:59 PM
8:30 PM
10:30
2:30
1:59 PM
8:30 PM
10:30
2:30
1:59 PM
7:30 PM
9:30
1:30
1:59 PM
8:30 PM
10:30
2:30
1:59 PM
1:59 PM
0:00
00:00
1:59 PM
9:00 PM
11:00
3:00
1:59 PM
9:00 PM
11:00
3:00
1:59 PM
8:30 PM
10:30
2:30
10:15 AM
8:15 PM
10:00
21:59
TOTAL

Salary
3800

O.T.P.
450.82

L.T.P
0.00

210:19

TOTAL

28:28

4250.82

b No.
ADVANCE
20252711
Less Time
Date
ADVANCE
00:00
6/21/2011
2500
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
00:00
0:00 TOTAL (-)
ADDL (+)
REM

1750.82

PAID

2200

4250.82

2500

NAME
Duty Hrs Salary
Month
Mob No.
SHAKIR
8:00
5500
JUNE
9770515133
Date
Day
A.Time
D.Time
Total Time Over Time Less Time
6/1/2011 Wednesday 12:30 PM
8:30 PM
8:00
0:00
00:00
6/2/2011 Thursday
11:45 AM
8:30 PM
8:45
0:45
00:00
6/3/2011 Friday
11:30 AM
8:30 PM
9:00
1:00
00:00
6/4/2011 Saturday
12:00 PM
8:00 PM
15:59
23:59
00:00
6/5/2011 Sunday
10:00 AM 10:00 AM
0:00
00:00
00:00
6/6/2011 Monday
11:45 AM
8:45 PM
14:59
22:59
00:00
6/7/2011 Tuesday
12:00 PM
8:30 PM
0:00
0:30
00:00
6/8/2011 Wednesday 12:00 PM
9:00 PM
9:00
22:59
00:00
6/9/2011 Thursday
12:00 PM
8:20 PM
8:20
23:39
00:00
6/10/2011 Friday
12:00 PM
8:00 PM
15:59
23:59
00:00
6/11/2011 Saturday
12:00 PM
8:00 PM
15:59
23:59
00:00
6/12/2011 Sunday
1:59 PM
1:59 PM
0:00
00:00
00:00
6/13/2011 Monday
12:00 PM
8:15 PM
8:15
23:44
00:00
6/14/2011 Tuesday
11:45 AM
8:20 PM
8:35
23:24
00:00
6/15/2011 Wednesday 11:30 AM
8:30 PM
9:00
1:00
00:00
6/16/2011 Thursday
12:00 PM
8:30 PM
0:00
0:30
00:00
6/17/2011 Friday
11:30 AM
8:30 PM
9:00
1:00
00:00
6/18/2011 Saturday
1:59 PM
1:59 PM
0:00
00:00
08:00
6/19/2011 Sunday
1:59 PM
1:59 PM
0:00
00:00
00:00
6/20/2011 Monday
1:59 PM
1:59 PM
0:00
00:00
08:00
6/21/2011 Tuesday
1:59 PM
1:59 PM
0:00
00:00
08:00
6/22/2011 Wednesday
1:59 PM
1:59 PM
0:00
00:00
08:00
6/23/2011 Thursday
12:00 PM
8:30 PM
0:00
0:30
00:00
6/24/2011 Friday
1:59 PM
1:59 PM
0:00
00:00
08:00
6/25/2011 Saturday
11:15 AM
8:15 PM
9:00
22:59
00:00
6/26/2011 Sunday
1:59 PM
1:59 PM
0:00
00:00
00:00
6/27/2011 Monday
12:00 PM
7:30 PM
7:30
00:00
00:30
6/28/2011 Tuesday
11:45 AM
9:00 PM
9:15
22:44
00:00
6/29/2011 Wednesday 12:15 PM
8:30 PM
8:15
23:44
00:00
6/30/2011 Thursday
12:45 PM
8:20 PM
7:35
00:00
00:25
TOTAL
Salary
5500

O.T.P.
-10.40

L.T.P
937.67

86:29

TOTAL

-0:27

40:55

4551.93

ADVANCE
2500
Date
ADVANCE
6/17/2011
3000
BILL
230

TOTAL (-)
ADDL (+)
REM

3230
1321.93

PAID

1580

NAME
Duty Hrs Salary
Month
Mob No.
LALA
8:00
5000
JUNE
9754786951
Date
Day
A.Time
D.Time
Total Time Over Time Less Time
6/1/2011 Wednesday 10:30 AM
5:00 PM
6:30
00:00
01:30
6/2/2011 Thursday
10:00 AM
9:00 PM
11:00
3:00
00:00
6/3/2011 Friday
10:30 AM
9:30 PM
11:00
3:00
00:00
6/4/2011 Saturday
10:30 AM
9:30 PM
11:00
20:59
00:00
6/5/2011 Sunday
10:30 AM
8:00 PM
9:30
9:30
00:00
6/6/2011 Monday
10:30 AM 10:30 PM
12:00
4:00
00:00
6/7/2011 Tuesday
10:30 AM
9:30 PM
11:00
3:00
00:00
6/8/2011 Wednesday 10:30 AM 10:30 PM
12:00
4:00
00:00
6/9/2011 Thursday
10:30 AM 10:30 PM
12:00
19:59
00:00
6/10/2011 Friday
10:30 AM 10:30 PM
12:00
19:59
00:00
6/11/2011 Saturday
9:00 AM 10:30 PM
13:30
5:30
00:00
6/12/2011 Sunday
9:00 AM
9:30 PM
12:30
12:30
00:00
6/13/2011 Monday
9:30 AM 10:30 PM
10:59
18:59
00:00
6/14/2011 Tuesday
9:00 AM 10:00 PM
13:00
5:00
00:00
6/15/2011 Wednesday
9:00 AM 12:00 AM
15:00
7:00
00:00
6/16/2011 Thursday
9:00 AM 10:00 PM
13:00
5:00
00:00
6/17/2011 Friday
9:00 AM
9:30 PM
12:30
19:29
00:00
6/18/2011 Saturday
9:00 AM 11:00 PM
14:00
17:59
00:00
6/19/2011 Sunday
9:00 AM
9:00 PM
12:00
12:00
00:00
6/20/2011 Monday
9:00 AM 10:30 PM
13:30
5:30
00:00
6/21/2011 Tuesday
9:00 AM
9:30 PM
12:30
19:29
00:00
6/22/2011 Wednesday
9:00 AM 10:30 PM
13:30
5:30
00:00
6/23/2011 Thursday
9:00 AM 10:30 PM
13:30
5:30
00:00
6/24/2011 Friday
9:00 AM 10:30 PM
13:30
5:30
00:00
6/25/2011 Saturday
9:00 AM 10:00 PM
13:00
5:00
00:00
6/26/2011 Sunday
10:00 AM
9:00 PM
11:00
11:00
00:00
6/27/2011 Monday
10:00 AM
5:00 PM
7:00
00:00
01:00
6/28/2011 Tuesday
10:00 AM 10:00 AM
0:00
00:00
08:00
6/29/2011 Wednesday 10:00 AM 10:00 AM
0:00
00:00
08:00
6/30/2011 Thursday
10:30 AM 10:00 PM
11:30
3:30
00:00
TOTAL
Salary
O.T.P. L.T.P
5000 1749.51
385.42

309:29

TOTAL

83:58

18:30

6364.10

ADVANCE
2500
Date
ADVANCE
6/20/2011
3000

TOTAL (-)
ADDL (+)
REM

3000
150
3514.10

PAID

4800

NAME
MANSINGH
Date
Day
6/1/2011 Wednesday
6/2/2011 Thursday
6/3/2011 Friday
6/4/2011 Saturday
6/5/2011 Sunday
6/6/2011 Monday
6/7/2011 Tuesday
6/8/2011 Wednesday
6/9/2011 Thursday
6/10/2011 Friday
6/11/2011 Saturday
6/12/2011 Sunday
6/13/2011 Monday
6/14/2011 Tuesday
6/15/2011 Wednesday
6/16/2011 Thursday
6/17/2011 Friday
6/18/2011 Saturday
6/19/2011 Sunday
6/20/2011 Monday
6/21/2011 Tuesday
6/22/2011 Wednesday
6/23/2011 Thursday
6/24/2011 Friday
6/25/2011 Saturday
6/26/2011 Sunday
6/27/2011 Monday
6/28/2011 Tuesday
6/29/2011 Wednesday
6/30/2011 Thursday

Duty Hrs Salary


Month
Mob No.
8:00
JUNE
A.Time
D.Time
Total Time Over Time
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
TOTAL

Salary
0

O.T.P.
0.00

L.T.P
0.00

0:00

TOTAL

0:00

0.00

b No.

ADVANCE
Less Time
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00

Date

208:00 TOTAL (-)


ADDL (+)
REM

0.00

PAID

ADVANCE

0
0.00

NAME
JEETESH
Date
Day
6/1/2011 Wednesday
6/2/2011 Thursday
6/3/2011 Friday
6/4/2011 Saturday
6/5/2011 Sunday
6/6/2011 Monday
6/7/2011 Tuesday
6/8/2011 Wednesday
6/9/2011 Thursday
6/10/2011 Friday
6/11/2011 Saturday
6/12/2011 Sunday
6/13/2011 Monday
6/14/2011 Tuesday
6/15/2011 Wednesday
6/16/2011 Thursday
6/17/2011 Friday
6/18/2011 Saturday
6/19/2011 Sunday
6/20/2011 Monday
6/21/2011 Tuesday
6/22/2011 Wednesday
6/23/2011 Thursday
6/24/2011 Friday
6/25/2011 Saturday
6/26/2011 Sunday
6/27/2011 Monday
6/28/2011 Tuesday
6/29/2011 Wednesday
6/30/2011 Thursday

Duty Hrs Salary


Month
Mob No.
8:00
JUNE
A.Time
D.Time
Total Time Over Time
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
10:30 AM 10:30 AM
0:00
00:00
TOTAL

Salary
0

O.T.P.
0.00

L.T.P
0.00

0:00

TOTAL

0:00

0.00

b No.

ADVANCE
Less Time
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00
8:00
8:00
00:00
8:00
8:00
8:00
8:00

Date

208:00 TOTAL (-)


ADDL (+)
REM

0.00

PAID

ADVANCE

0
0.00

You might also like