Hi all,
I am creating a spreadsheet for a staff roster. The sheet works great, employee's hours are calculated and everything works fine.....Until I roster an employee to finish past midnight.
I did some googling and found a formula which is : =MOD((D10-C10),1) , where D10 is the finish time and C10 is the start time, but I still have 2 issues.
- Firstly in my total hours worked for the day (which is every employees individual hours totalled) it doesn't add together properly.
- Secondly, I need a formula that uses IF so that the sheet can figure out if an employee has worked and ended before midnight and us the normal calculation or if they worked past midnight and it needs to use the MOD formula. Im assuming it would be something like =IF([finish time]-[start time]<0 then MOD (([finish time]-[start time]),1
I need the sheet to understand if its a midnight sheet by itself so that I dont need to create a whole extra section for people that work past midnight.
If anyone could help, I'd appreciate it