Hi I want to do this in excel the figures are hours and min
Historically our wage staff entered contracted hours into our system without the unpaid break (at 5mins Per hour deduction) ie Sam is contracted to 40 hours but the system only shows 36:40. I need to
36hrs 40mins divide by 55mins multiplied by 60mins in a formula to correct everyone actual contracted hours