This is a simple job for a person that is proficient with excel and its function.
4-6 formulas to be created, most of which are done but missing a part of the functionality.
It will take longer to explain then execute. More work will come as I want to automatise the work flow and reporting but it if for the future.
Basically this is a time sheet, hours gets imputed and people get paid rate 1 from midnight to 7am,rate 2 from 7am till 7pm and rate 3 from 7pm till midnight. We need to split automatically the if a person works lets say from 6am till 9pm plus 1 h break, we need to have 1h rate 1, 12h -1h break rate 2 and for rate 3 we have 2h. as simple as that, if a person works 0 hours it should be 0. The rest of the work for this job is very similar to this, I won't explain it all right now.
I'll provide the file and we can have a quick explanation once the job is assigned.
Thanks, looking forward to work with you
February 19, 2018
I am willing to pay higher rates for the most experienced freelancers