Auto Calculating Time Sheet
We need a time sheet that automatically calculates daily hours worked,
overtime over 8hrs, and double overtime if 7 days worked(if over 40min). Anyone developed this yet? |
Please clarify 1. Calculate daily hours worked. 2. Pay overtime in excess of 8 hours daily 3. Pay double overtime to anything in excess of 40 min if the person worked for the 7 days, and single OT to anything less than 40 minutes in excess of 8 hours. Is that what you need ? Regards Juan Carlos -- cscorp ------------------------------------------------------------------------ cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015 View this thread: http://www.excelforum.com/showthread...hreadid=376867 |
All times are GMT +1. The time now is 11:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com