Timesheet analysis
Budget: $30 – $250 AUD
i need to analyze a set of timesheet and determine the following output
shifts where start time are earlier or later than rostered time (in minutes)
shifts where end time are earlier or later than rostered time
split shifts - where the end of one shift and commencement of the other shift is more than one hours but less than 10 hours
challenges .. the data set -... broken shifts .. shifts worked passed midnight..
shifts where start time are earlier or later than rostered time (in minutes)
shifts where end time are earlier or later than rostered time
split shifts - where the end of one shift and commencement of the other shift is more than one hours but less than 10 hours
challenges .. the data set -... broken shifts .. shifts worked passed midnight..