| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
time sheet calculations
)What formulas to use (for O/T) on a weekly time sheet that contains multiple
overtime rates: Ord Time X 7 MON-FRI 8th hr X 1.5 9hr+ X 2 Saturdays - Ord Time X 5 - 6th hr X 1.5 - 7th+ hrs X 2 Sundays - All time X 2 Public Holidays - All times X 3 End column should display total payable hours |
|
#2
|
|||
|
|||
|
It would help to see some sample data.
-- HTH RP (remove nothere from the email address if mailing direct) "emmcee" wrote in message ... )What formulas to use (for O/T) on a weekly time sheet that contains multiple overtime rates: Ord Time X 7 MON-FRI 8th hr X 1.5 9hr+ X 2 Saturdays - Ord Time X 5 - 6th hr X 1.5 - 7th+ hrs X 2 Sundays - All time X 2 Public Holidays - All times X 3 End column should display total payable hours |
|
#3
|
|||
|
|||
|
can I email u direct with an example attachment. Doesn't look like we can
make attachments to these replies. regards Daily Time sheet RATES BASIC M-F(1) O/T M-F(2) O/T Sat(1) O/T Sat(2) O/T Month August Rates: M-F Basic X 7hrs 8th hr X 1.5 8+ hrs X 2 7.00 8.00 9.00 Sat: Basic X 5hrs 6th hr X 1.5 6+ hrs X 2 5.00 6.00 7.00 Sun: All X 2 0.00 Public Hol: All X 3 0.00 Date Day Start Time Break Time Break Time Finish Time Total Hours Worked Basic Rate O/T Rate O/T Rate O/T Rate O/T Rate Start Finish Total 1.5 2.00 3.00 Hours Hours Hours Hours Hours 8/12/2005 Friday 7.00 12.00 13.00 15.00 8.00 7.00 7.00 0.00 8/13/2005 Saturday 6.25 12.00 13.00 16.00 9.75 8.75 5.00 3.75 1.00 2.75 8/14/2005 Sunday 9.25 12.00 13.00 17.30 8.05 7.05 0.00 7.05 7.05 8/15/2005 Monday 7.55 12.00 13.00 14.45 6.90 5.90 5.90 0.00 8/16/2005 Tuesday 9.15 12.00 13.00 15.05 5.90 4.90 4.90 0.00 8/17/2005 Wednesday 14.30 18.15 3.85 3.85 0.00 3.85 v v 3.85 8/18/2005 Thursday 8.25 12.00 13.00 18.50 10.25 9.25 7.00 2.25 v v Total Hours 52.70 46.70 29.80 16.90 9.80 Payable Hours EXAMPLE mike cochrane "Bob Phillips" wrote: It would help to see some sample data. -- HTH RP (remove nothere from the email address if mailing direct) "emmcee" wrote in message ... )What formulas to use (for O/T) on a weekly time sheet that contains multiple overtime rates: Ord Time X 7 MON-FRI 8th hr X 1.5 9hr+ X 2 Saturdays - Ord Time X 5 - 6th hr X 1.5 - 7th+ hrs X 2 Sundays - All time X 2 Public Holidays - All times X 3 End column should display total payable hours |
|
#4
|
|||
|
|||
|
You can if you wish.
-- HTH RP (remove nothere from the email address if mailing direct) "emmcee" wrote in message ... can I email u direct with an example attachment. Doesn't look like we can make attachments to these replies. regards Daily Time sheet RATES BASIC M-F(1) O/T M-F(2) O/T Sat(1) O/T Sat(2) O/T Month August Rates: M-F Basic X 7hrs 8th hr X 1.5 8+ hrs X 2 7.00 8.00 9.00 Sat: Basic X 5hrs 6th hr X 1.5 6+ hrs X 2 5.00 6.00 7.00 Sun: All X 2 0.00 Public Hol: All X 3 0.00 Date Day Start Time Break Time Break Time Finish Time Total Hours Worked Basic Rate O/T Rate O/T Rate O/T Rate O/T Rate Start Finish Total 1.5 2.00 3.00 Hours Hours Hours Hours Hours 8/12/2005 Friday 7.00 12.00 13.00 15.00 8.00 7.00 7.00 0.00 8/13/2005 Saturday 6.25 12.00 13.00 16.00 9.75 8.75 5.00 3.75 1.00 2.75 8/14/2005 Sunday 9.25 12.00 13.00 17.30 8.05 7.05 0.00 7.05 7.05 8/15/2005 Monday 7.55 12.00 13.00 14.45 6.90 5.90 5.90 0.00 8/16/2005 Tuesday 9.15 12.00 13.00 15.05 5.90 4.90 4.90 0.00 8/17/2005 Wednesday 14.30 18.15 3.85 3.85 0.00 3.85 v v 3.85 8/18/2005 Thursday 8.25 12.00 13.00 18.50 10.25 9.25 7.00 2.25 v v Total Hours 52.70 46.70 29.80 16.90 9.80 Payable Hours EXAMPLE mike cochrane "Bob Phillips" wrote: It would help to see some sample data. -- HTH RP (remove nothere from the email address if mailing direct) "emmcee" wrote in message ... )What formulas to use (for O/T) on a weekly time sheet that contains multiple overtime rates: Ord Time X 7 MON-FRI 8th hr X 1.5 9hr+ X 2 Saturdays - Ord Time X 5 - 6th hr X 1.5 - 7th+ hrs X 2 Sundays - All time X 2 Public Holidays - All times X 3 End column should display total payable hours |
|
#6
|
|||
|
|||
|
Take out nothere from the addy.
-- HTH RP (remove nothere from the email address if mailing direct) "emmcee" wrote in message ... email to the above bounced back on me....pls chk n advise "Bob Phillips" wrote: You can if you wish. -- HTH RP (remove nothere from the email address if mailing direct) "emmcee" wrote in message ... can I email u direct with an example attachment. Doesn't look like we can make attachments to these replies. regards Daily Time sheet RATES BASIC M-F(1) O/T M-F(2) O/T Sat(1) O/T Sat(2) O/T Month August Rates: M-F Basic X 7hrs 8th hr X 1.5 8+ hrs X 2 7.00 8.00 9.00 Sat: Basic X 5hrs 6th hr X 1.5 6+ hrs X 2 5.00 6.00 7.00 Sun: All X 2 0.00 Public Hol: All X 3 0.00 Date Day Start Time Break Time Break Time Finish Time Total Hours Worked Basic Rate O/T Rate O/T Rate O/T Rate O/T Rate Start Finish Total 1.5 2.00 3.00 Hours Hours Hours Hours Hours 8/12/2005 Friday 7.00 12.00 13.00 15.00 8.00 7.00 7.00 0.00 8/13/2005 Saturday 6.25 12.00 13.00 16.00 9.75 8.75 5.00 3.75 1.00 2.75 8/14/2005 Sunday 9.25 12.00 13.00 17.30 8.05 7.05 0.00 7.05 7.05 8/15/2005 Monday 7.55 12.00 13.00 14.45 6.90 5.90 5.90 0.00 8/16/2005 Tuesday 9.15 12.00 13.00 15.05 5.90 4.90 4.90 0.00 8/17/2005 Wednesday 14.30 18.15 3.85 3.85 0.00 3.85 v v 3.85 8/18/2005 Thursday 8.25 12.00 13.00 18.50 10.25 9.25 7.00 2.25 v v Total Hours 52.70 46.70 29.80 16.90 9.80 Payable Hours EXAMPLE mike cochrane "Bob Phillips" wrote: It would help to see some sample data. -- HTH RP (remove nothere from the email address if mailing direct) "emmcee" wrote in message ... )What formulas to use (for O/T) on a weekly time sheet that contains multiple overtime rates: Ord Time X 7 MON-FRI 8th hr X 1.5 9hr+ X 2 Saturdays - Ord Time X 5 - 6th hr X 1.5 - 7th+ hrs X 2 Sundays - All time X 2 Public Holidays - All times X 3 End column should display total payable hours |
|
#7
|
|||
|
|||
|
I run a small business. If you would not mind I'd like to ask if I could have a copy of your excel file for use among my employees. Thanks. N A -- nander ------------------------------------------------------------------------ nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156 View this thread: http://www.excelforum.com/showthread...hreadid=396754 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete all named ranges in a sheet at one time? | Excel Worksheet Functions | |||
| Time stamp in Excel Sheet | Excel Discussion (Misc queries) | |||
| How to set up weekly time sheet with flexi time. | Excel Worksheet Functions | |||
| time sheet calc by time in and out | Excel Worksheet Functions | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Linear Mode
