+ Reply to Thread
Results 1 to 5 of 5

Calculating Formula Problem for Time Sheet

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    3

    Calculating Formula Problem for Time Sheet

    I am trying to create a formula in my time sheet that will allow me to add the hours worked up to forty in one column and then any hours over forty is put into an overtime column. I'm getting tied up on the formulas! Any help is greatly appreciated. I've attached an example to show you what I'm looking at.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,452

    Re: Calculating Formula Problem for Time Sheet

    Something like =min(sum( your_range),40) for the first part and = max(0,40-sum(your_range) in the second

  3. #3
    Registered User
    Join Date
    05-13-2014
    Location
    Best
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Calculating Formula Problem for Time Sheet

    HM,

    I guess you normally work 8 hrs a day in FLA.
    Is it correct you want to calculate the overtime on a weekly basis?

    Please elucidate
    MOD timesheet example.xlsx

  4. #4
    Registered User
    Join Date
    10-28-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    3

    Re: Calculating Formula Problem for Time Sheet

    Yes, our OT is calculated on a weekly basis not daily.

  5. #5
    Registered User
    Join Date
    10-28-2014
    Location
    Orlando, FL
    MS-Off Ver
    2010
    Posts
    3

    Re: Calculating Formula Problem for Time Sheet

    I forgot to note originally I need the hours to calculate daily and separate out once forty hours are reached because my techs hourly rate can vary based on the job they are performing for the day. Sorry.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with calculating an excel formula from one sheet to another Help
    By susiesc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2013, 11:27 PM
  2. Problem with Formula in Time Sheet
    By sportsys in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2009, 06:15 PM
  3. Time calculating problem
    By ru1peh in forum Excel General
    Replies: 2
    Last Post: 08-05-2006, 04:05 AM
  4. Problem with calculating time
    By Lee in forum Excel General
    Replies: 9
    Last Post: 03-14-2006, 05:00 PM
  5. [SOLVED] Cumulative Time Problem calculating more than 24 hours.
    By J in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2005, 11:05 AM

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