+ Reply to Thread
Results 1 to 6 of 6

Overtime Calculator with conditions

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Cool Overtime Calculator with conditions

    I am trying to make an ovetime calculator that sums up the number of hours between two dates and two times. That's pretty easy - the hard part is the conditions I have. I have a table on how many minutes count as a decimal. So every 6 minutes = .1 added to the time. If you don't make it to the next 6 minute interval (10 minutes) then you have to remain at .1

    I am looking for a formula to incorporate my conditions to be able to get the proper overtime number I am looking for.

    An example is included.

    Thanks for the help.

    Overtime Calculator.xlsx

  2. #2
    Registered User
    Join Date
    06-14-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Overtime Calculator with conditions

    Overtime Calculator.xlsx

    Check out the attachment.

    Regards,
    Mohan.Y

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Overtime Calculator with conditions

    Thank you very much. This was a lot of help.

  4. #4
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Overtime Calculator with conditions

    I appreciate the help but I did notice a little glitch. It looks like the table index is added to whatever the result of the two times are. So when I type in 6:00 to 8:30 it results in 3 hours because it takes the 2.5 hours and adds 0.5 from my index. Any help on this?

  5. #5
    Registered User
    Join Date
    06-14-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Overtime Calculator with conditions

    Overtime Calculator.xlsx

    Good Observation. Yes...It is a formulae mistake.

    Attached the revised file.

    Regards,
    Mohan.Y

  6. #6
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Overtime Calculator with conditions

    Perfect. This is great. I think this will help a lot of people at my organization. Thank you so much.

+ Reply to 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