+ Reply to Thread
Results 1 to 3 of 3

Converting time into cumulative minutes

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    Chiltern, Australia
    MS-Off Ver
    Excel2007 and 2010
    Posts
    4

    Converting time into cumulative minutes

    Hi everyone,

    I work for an FMCG company and I am trying to put together a daily report that tells everyone how far ahead or behind plan the lines are. (We have 25 lines)
    I have a planned finish time in DD:MM:YYYY HH:MM and I have a current time in the same format.
    What I am looking for is the number of minutes between these two times so that I can say Line 1 has 100 minutes until the plan says production should be finished.

    The minute format needs to be a number so that I can use this to work out qty of shippers left.

    So say it another way,
    I can work out how many minutes left to finish the production given the quantity of shippers left to make and the nominal speed. e.g 100 minutes to finish production
    I can work out how many minutes until the production was planned to finish if the deadline has not past.

    I can't work out how to get the time after the deadline has past (e.g. -100 minutes)
    or
    to get the total minutes between planned finished and current time over multiple days.(e.g. 15th - 17th)
    or
    have a format that i can use to compute the ahead behind time.

    I need these because I am saying;
    Given that it will take 960mins to finish production given the planned quantity.
    And there is 1020 minutes until the plan says we should be finished then

    1020-960=60

    This means we are 60 minutes ahead of plan.

    Hope your collective wisdom can help me solve this issue.

    I am just finishing a 12 hour night shift and wont be back until Thursday DS Australian time, so if I don't reply promptly I am not being rude, I am just not here.

    Thanks to all.

    Kieran

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Converting time into cumulative minutes

    *1440_______________

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    Chiltern, Australia
    MS-Off Ver
    Excel2007 and 2010
    Posts
    4

    Re: Converting time into cumulative minutes

    Thanks, but I have figured it out. No response necessary. And no *1440 would not be an appropriate answer.

+ 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. Converting time from minutes to 100ths
    By angelia.washington in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2014, 04:46 PM
  2. converting minutes to time
    By tommy060289 in forum Excel General
    Replies: 3
    Last Post: 03-09-2012, 12:20 PM
  3. converting cumulative time to workweek time
    By Ccsachs in forum Excel General
    Replies: 0
    Last Post: 02-01-2012, 03:06 PM
  4. Converting hours and minutes in military time to minutes
    By Argile79 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-13-2010, 02:42 PM
  5. Time - converting HH:MM:SS to Minutes
    By Noel S Pamfree in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2005, 01:06 PM

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