So let's say you have
Column A: Time In
Column B: Time Out
Column C: B - A - Lunch hour
Column D: Hourly Rate
Column E: Calculate Rate (C*D)+((C-8)*(D/2))
Sum of Column E is your Weekly Payroll Projection
Your formula would be a bit different if you calculate 40 hour week
overtimes and other stuff. but this is the basis of it. This is why I
say it depend on how you send up the schedule (And I should have said
how you set up the spreadsheet)
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile:
http://www.excelforum.com/member.php...o&userid=35016
View this thread:
http://www.excelforum.com/showthread...hreadid=558530