I am trying to figure out formulas to set up scheduling and I used the           =(a2-a1)*24 formula and all of the closers that work til midnight show a negative amount below the hours.  How do I factor in the time worked between those shifts?
How do I factor in an employee working say 4:00 pm to 12:00 am (midnight)?
google spreadsheets