Staff Availability

[vardhancse]

hi,

I have one requirement based on 2 data sets:

1. Staff roster

2. Leave data

Requirement:

Line Chart

x axis: time (hh:mm)

Y Axis:  Calculate # of staff available ( Total FTE on Roster - Total FTE on LEave)

On selected date like for e.g 11/05/2018

I need to have staff availability based on roster and leave

PFA excel "Roster", "Leave" & "Chart"

[vardhancse]

duncanblaine‌

[vardhancse]

jagan‌