Closed Thread
Results 1 to 2 of 2

If Formula for hours worked more or less than regular hours

  1. #1
    Registered User
    Join Date
    11-24-2010
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    3

    If Formula for hours worked more or less than regular hours

    I have a sheet that already has the total hours worked out (A1=date; B1=Day; C1=Start time; D1=End Time; E1=Total Hours; F1=Lunch 1/2 hour; G1=Total hours worked in that day). I now need a IF formula that can work out, per day, any hours above the regular 8 hours and any hours below the regular 8 hours and then at the end of the column SUM all the row values to give a total of what the actual overtime would be.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: If Formula for hours worked more or less than regular hours

    Please take a moment to read the forum rules and then post your question in one of the question forums. Tips and Tutorials is not one.

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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