LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Overtime calculations

I need to keep track of my work times. I just want to input the start time,
finish time and lunch break. After that I would like the sheet to calculate
the following

Total Hours worked
Total Hours worked less lunch break
Overtime after 8 hours calculated at 1.5
Overtime calculated after 10 hours at double time.
Overtime Saturday calculated at 1.5 for the first 2 hours then double time
for the remainder
Overtime Sunday calculated at double time.

I have looked everywhere for a program to do this, or a template that I can
do it with Excel, but so far no good. Can anyone tell me where I could find
this? Please bear in mind that I am not a programmer and am looking for a
ready made solution.
Thanks
 
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
Need help calculating overtime to date BVHis Excel Worksheet Functions 8 January 9th 06 05:59 PM
Could you help me to calculate overtime Svetlana Excel Worksheet Functions 10 August 25th 05 09:00 AM
Calculations crossing multiple sheets Stephen McArthu Excel Discussion (Misc queries) 4 June 6th 05 04:35 PM
overtime templates Flash Excel Worksheet Functions 1 April 29th 05 08:09 PM
Overtime Calculations Doug Excel Worksheet Functions 1 March 8th 05 12:57 AM


All times are GMT +1. The time now is 12:23 AM.

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

About Us

"It's about Microsoft Excel"