+ Reply to Thread
Results 1 to 4 of 4

How to calculate overtime hours in Excel using formulas?

  1. #1
    Toeknee
    Guest

    How to calculate overtime hours in Excel using formulas?

    I need information on how to enter the proper syntax (formula) so that excel
    can calculate overtime hours. In california over 8 hrs in one day is
    overtime. The 8 would be considered regular hours and anything over is OT.

  2. #2
    Niek Otten
    Guest

    Re: How to calculate overtime hours in Excel using formulas?

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

    --
    Kind regards,

    Niek Otten

    "Toeknee" <Toeknee@discussions.microsoft.com> wrote in message
    news:B90A888E-AC70-4FB7-9A25-1EDF256709A9@microsoft.com...
    >I need information on how to enter the proper syntax (formula) so that
    >excel
    > can calculate overtime hours. In california over 8 hrs in one day is
    > overtime. The 8 would be considered regular hours and anything over is
    > OT.




  3. #3
    bpeltzer
    Guest

    RE: How to calculate overtime hours in Excel using formulas?

    If the hours worked in a given day are in cell B2, the overtime hours are
    calculated by =max(0,b2-8). Basically, just subtract 8 (the regular hours).
    The max ensures that you don't post negative OT hours if the total hours is
    less than 8.
    --Bruce

    "Toeknee" wrote:

    > I need information on how to enter the proper syntax (formula) so that excel
    > can calculate overtime hours. In california over 8 hrs in one day is
    > overtime. The 8 would be considered regular hours and anything over is OT.


  4. #4
    Registered User
    Join Date
    04-28-2014
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: How to calculate overtime hours in Excel using formulas?

    Having Problem to compute my Overtime in Hours

    Let Say
    A1 = time In 06:00
    B1 = time Out 22:00
    C1 = Overtime ?????Formula

    Thanks

+ 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