Thread: time sheet calculations

It would help to see some sample data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"emmcee" <emmcee@discussions.microsoft.com> wrote in message
news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> )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" <emmcee@discussions.microsoft.com> wrote in message
> news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > )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" <emmcee@discussions.microsoft.com> wrote in message
news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> 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" <emmcee@discussions.microsoft.com> wrote in message
> > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > )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
> >
> >
> >

bob.phillips@notheretiscali.co.uk
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" <emmcee@discussions.microsoft.com> wrote in message
> news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> > 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" <emmcee@discussions.microsoft.com> wrote in message
> > > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > > )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" <emmcee@discussions.microsoft.com> wrote in message
news:9DA70BD9-6986-4F80-9AA9-1BD8C2B11EB9@microsoft.com...
> bob.phillips@notheretiscali.co.uk
> 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" <emmcee@discussions.microsoft.com> wrote in message
> > news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> > > 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" <emmcee@discussions.microsoft.com> wrote in message
> > > > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > > > )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" <emmcee@discussions.microsoft.com> wrote in message
news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> )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" <emmcee@discussions.microsoft.com> wrote in message
> news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > )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" <emmcee@discussions.microsoft.com> wrote in message
news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> 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" <emmcee@discussions.microsoft.com> wrote in message
> > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > )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
> >
> >
> >

bob.phillips@notheretiscali.co.uk
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" <emmcee@discussions.microsoft.com> wrote in message
> news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> > 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" <emmcee@discussions.microsoft.com> wrote in message
> > > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > > )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" <emmcee@discussions.microsoft.com> wrote in message
news:9DA70BD9-6986-4F80-9AA9-1BD8C2B11EB9@microsoft.com...
> bob.phillips@notheretiscali.co.uk
> 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" <emmcee@discussions.microsoft.com> wrote in message
> > news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> > > 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" <emmcee@discussions.microsoft.com> wrote in message
> > > > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > > > )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" <emmcee@discussions.microsoft.com> wrote in message
news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> )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" <emmcee@discussions.microsoft.com> wrote in message
> news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > )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" <emmcee@discussions.microsoft.com> wrote in message
news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> 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" <emmcee@discussions.microsoft.com> wrote in message
> > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > )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
> >
> >
> >

bob.phillips@notheretiscali.co.uk
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" <emmcee@discussions.microsoft.com> wrote in message
> news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> > 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" <emmcee@discussions.microsoft.com> wrote in message
> > > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > > )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" <emmcee@discussions.microsoft.com> wrote in message
news:9DA70BD9-6986-4F80-9AA9-1BD8C2B11EB9@microsoft.com...
> bob.phillips@notheretiscali.co.uk
> 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" <emmcee@discussions.microsoft.com> wrote in message
> > news:CDC25841-9250-4EDE-9971-29524E81DCC2@microsoft.com...
> > > 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" <emmcee@discussions.microsoft.com> wrote in message
> > > > news:B874F6A7-CA02-40A4-96E4-3D09EF6CF3DC@microsoft.com...
> > > > > )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
> > > >
> > > >
> > > >
> >
> >
> >