hello,
I am frustrated with this simple weekly payroll formula as the final results continue to be the same (-9). I am also getting a curcular error. My start time would be 9:00 am and my finish time would be 6:15 pm. If total time is greater than 6 hours, one hour would be deducted from the total time. This is my formula =IF((B3<B4),((B3-B4)*24),"IF((C4=>6-1)"). Can anyone please help me with this.
Thanks in advance.