Good Morning,
I am trying to create a work schedule that will automatically subtract a 1/2 hour lunch provided the employee is scheduled to work more than 6 hours. I've attached (I hope) a workbook with an sample of my formula. (I'm using the second sheet to calculate the number of hours worked.)
The below formula calculates the hours fine.
=(Schedule!B3-Schedule!B2)*24
When I use the below it subtracts the 0.5 even if 0 hours are scheduled and I'm not excel savvy enough to figure out what I'm doing wrong!
=(Schedule!B3-Schedule!B2)*24+IF(6,-0.5)
Thanks in advance for your help.
Bookmarks