Posted to microsoft.public.excel.misc

Andy Bolger Andy Bolger is offline

external usenet poster

Posts: 8

timesheet and overtime formula/s

Col D5: Start time
Col E5: Finish time
Col F5: Ordinary Hours

Above are all worked out, my problem is in calculating overtime
automatically and placing in:

Col H5: I want time and a half (first 3 hours)
Col I5: I want double time (after first 3 hours)

Many thanks

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
Timesheet, overtime with daytime from 7:30am to 16:30pm	Arkon	Excel Discussion (Misc queries)	2	October 1st 06 10:13 PM
Calculating timesheet with overtime	Ewak@job1usa	Excel Worksheet Functions	2	January 31st 06 05:38 PM
overtime on timesheet	kimmyrt	Excel Worksheet Functions	4	January 26th 05 07:33 PM
timesheet with running total of overtime	kimmyrt	Excel Worksheet Functions	2	January 26th 05 06:15 PM
timesheet with running totals of overtime	Gord Dibben	Excel Worksheet Functions	0	January 25th 05 12:45 AM

All times are GMT +1. The time now is 07:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us