Posted to microsoft.public.excel.newusers

Chase Michaels Chase Michaels is offline

external usenet poster

Posts: 1

calculating overtime

Startime: 6:00 Endtime: 22:00

up to 8 hours Reg hours = 8
8.1 to 12 hrs 1.5x ot = 4
12.1 to 14 2x ot = 2
14.1 and up 2.5x ot = 4

if they work 6 days straight up to 8 hrs is Reg anything over 8 is 2x ot. If
they work on the 7th day it is 2.5x ot.

Thanks for your help in advance
Chase

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Calculating overtime	bunnyc	Excel Discussion (Misc queries)	1	February 21st 06 12:36 AM
Calculating Overtime	sam13484 via OfficeKB.com	Excel Worksheet Functions	1	February 3rd 06 03:20 PM
Calculating timesheet with overtime	Ewak@job1usa	Excel Worksheet Functions	2	January 31st 06 05:38 PM
Need help calculating overtime to date	BVHis	Excel Worksheet Functions	8	January 9th 06 05:59 PM
Calculating overtime	jennerifw	New Users to Excel	3	August 9th 05 08:33 PM

All times are GMT +1. The time now is 05:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us