Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Durocdog
 
Posts: n/a
Default 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   Report Post  
cscorp
 
Posts: n/a
Default


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there away to keep "auto save" from jumping to the first work sheet in the work book? Marc New Users to Excel 2 April 21st 05 01:27 AM
I need an Excel bi-weekly employee time sheet template Books Excel Discussion (Misc queries) 4 April 4th 05 12:43 AM
Entering Data in multiple cells on one sheet & having it auto upda haynblend Excel Worksheet Functions 2 March 27th 05 01:41 AM
Is there a time sheet template that calculates hours? CTG Excel Discussion (Misc queries) 2 February 24th 05 09:49 PM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 07:52 PM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"