View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
payroll spreadsheet help payroll spreadsheet help is offline
external usenet poster
 
Posts: 1
Default payroll formula when shift is 3pm to 1 am

I am fine tuning our payroll spreadsheet, and we have several employees who
work from 4pm to 1 or 2 am. The current formula's treat each day as 24 hours,
ending at 12pm. Is there a formula that I can use to show the hours worked
when the ending time is after12 pm?