|
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 |
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 |
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 |
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 |
|
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 |
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 |
|
| All times are GMT +1. The time now is 10:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com