[TABLE="width: 2"]
<tbody>[TR]
[TD]
[TABLE="width: 1415"]
<tbody>[TR]
[TD="class: xl70, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl68, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, colspan: 2"]1
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]2
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]3
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]4
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]5
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]6
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]7
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]8
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]9
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]10
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]11
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]12
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]13
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]14
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]15
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]16
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]17
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]18
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]19
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]20
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]21
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]22
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]23
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]24
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]25
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]26
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]27
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]28
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]29
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]30
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]31
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]1
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]2
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]3
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]4
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 1415"]
<tbody>[TR]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]44.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]24.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]24.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]-
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]-
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I can' figure out the formula to sum the hours based on the type. So there are 3 letter for the time off schedule v (vacation), S (Sick) and E(extra vacation day). The column next to each box with code is hours. I have tried many sum ifs to total the entire month V, S D in 3 columns but I cut get it to sum the total hours
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]
[TABLE="width: 1415"]
<tbody>[TR]
[TD="class: xl70, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl72, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl68, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[TD="class: xl66, width: 49, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]M
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]W
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]T
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]F
[/TD]
[TD="class: xl65, width: 48, bgcolor: transparent, colspan: 2"]S
[/TD]
[TD="class: xl67, width: 40, bgcolor: transparent"]Total
[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent, colspan: 2"]1
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]2
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]3
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]4
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]5
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]6
[/TD]
[TD="class: xl72, bgcolor: transparent, colspan: 2"]7
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]8
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]9
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]10
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]11
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]12
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]13
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]14
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]15
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]16
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]17
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]18
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]19
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]20
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]21
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]22
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]23
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]24
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]25
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]26
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]27
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]28
[/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]29
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]30
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]31
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]1
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]2
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]3
[/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]4
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
[TABLE="width: 1415"]
<tbody>[TR]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]v
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]44.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]s
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8.0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]24.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"]E
[/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]8
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]24.0
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]-
[/TD]
[TD="class: xl68, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 25, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl67, width: 24, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 24, bgcolor: #EDEDED"]0
[/TD]
[TD="class: xl69, width: 40, bgcolor: transparent"]-
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I can' figure out the formula to sum the hours based on the type. So there are 3 letter for the time off schedule v (vacation), S (Sick) and E(extra vacation day). The column next to each box with code is hours. I have tried many sum ifs to total the entire month V, S D in 3 columns but I cut get it to sum the total hours
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]