+ Reply to Thread
Results 1 to 2 of 2

need help with formulas

  1. #1
    Registered User
    Join Date
    02-24-2007
    Posts
    1

    Smile need help with formulas

    I have created my time record to match my actual work record.
    The pdf shows this.
    This is for 1 week ending and then I will duplicate for the rest.
    theres probably a better way, but it is my first time

    formulas I need to create
    I need to work 40 hours per week to get ot on Saturday
    over 8 hours per day is ot
    sundays is double time only if I have 40 hours for the week
    total hours daily
    total hours weekly

    if you could just point me in the right direction

    sorry this is so long
    sorry this is so long
    gt82
    Attached Files Attached Files

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi there,

    Take a look at this link on timesheets and formulas, it may help you?

    http://www.cpearson.com/excel/overtime.htm
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1