Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
I need an Excel bi-weekly employee time sheet template | Excel Discussion (Misc queries) | |||
Entering Data in multiple cells on one sheet & having it auto upda | Excel Worksheet Functions | |||
Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions |