+ Reply to Thread
Results 1 to 2 of 2

Production Calculator

  1. #1
    Registered User
    Join Date
    10-16-2012
    Location
    Bakersfield, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Production Calculator

    Good Evening everyone i have a major calculation that i need to solve. At work we now are calculating a production number of time spent processing with exceptions. I need a formula that is going to calculate time, as well as minus out breaks and lunches as well as exceptions. So say a person worked a 8 hours shift, they get two 15 minute breaks and one 30 minute lunch. Their hours spent on processing would be 7.5 hours. Say that next day the person works another 8 hour shift, with an exception of 48 minutes due to system being down so they were not able to process for 48 minutes they would have worked 7.5 hours minus 48 minutes. I need to know how many hours and minutes they worked for that day with that exception

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,036

    Re: Production Calculator

    Hi
    Excel sees a day as 1 - an hour as 1/24 a minute as 1/1440, etc
    To return to decimal you should multiply by 24
    So, 48 minutes are 24*(48/1440) which you can subtract from the result you have obtained

+ 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