Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: i almost have it figured out

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to create a time sheet. I almost have it figured out. The overtime law for CAlif is
    DAILY OVERTIME COMPENSATION

    The law establishes new overtime compensation rules for employers. These rules apply to hourly employees who are non-union, not exempt and do not work under an alternative workweek schedule. Employers are required to pay their employees overtime as follows:

    Pay time and a-half pay after eight hours of daily work and double pay after 12 hours of daily work.
    Pay time and a-half pay after 40 hours of work in one workweek and for the first eight hours worked on the seventh day of work.
    Pay double time for hours worked in the excess of eight hours on any seventh day of a workweek.

    I have it all worked out except how to count if this is the seventh day worked. I can email anyone the file if you can help so that you can see what I have. Thanks

  2. #2
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    954
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    At home right now, so don't have access to excel, but using the weekday function is the answer. if weekday = 1, this is Sunday.

    Hope you can work it from here.





    George J

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •