+ Reply to Thread
Results 1 to 7 of 7

Time into critera

  1. #1
    Registered User
    Join Date
    09-05-2008
    Location
    Coventry
    Posts
    8

    Time into critera

    i have in a colomn the time in minutes, what formula can i use to work out if it is Between 1 - 5 Days, Between 5 - 10 Days, Between 10 - 15 Days, Between 15 - 30 Days, Between 30 - 60 Days or Over 60 Days?

    Last edited by Legendkiller; 09-15-2008 at 07:42 AM. Reason: Poor title

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    =A1/1440 gives how many days A1 minutes is equivalent to
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Here is one option (see encl.)
    HTH
    Ola
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-05-2008
    Location
    Coventry
    Posts
    8
    Thanks for the attachment, i tried using the formula on sheet 5 how ever it only gives a exact return if it matches exactly if it doesn't it returns Between 1 - 5 Days

  5. #5
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Hmm, it works for me.

    I presume...
    The setting is =MATCH(,,1) not =MATCH(,,0)? 1 means sorted The list is sorted in Ascending order.
    The minutes are not in Excel's time format?

    Then the only other option is Could you attach a sample file?

    //Ola

  6. #6
    Registered User
    Join Date
    09-05-2008
    Location
    Coventry
    Posts
    8
    ok have attached the file. Although i was looking at it this morning and have noticed it is hours in column C not minutes as first thought.

    Thanks
    Attached Files Attached Files

  7. #7
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Perhaps try this formula in Row 2... copied down:

    =LOOKUP(C2/24,{0,5,10,15,30,60},{"0 - 5","6 - 10","11 - 15","16 - 30","31 - 60","Over 60"})& " days"

    Make adjustments as necessary.

+ 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. Code Execution Degrades Over Time
    By KDT in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-25-2008, 04:28 PM
  2. Changing time
    By Ziggy_ks1 in forum Excel General
    Replies: 1
    Last Post: 04-21-2008, 10:42 PM
  3. Time w/in Each Hour of Day btwn a Time Range
    By gbrogmus in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-30-2007, 03:01 AM
  4. Date and Time Graphs
    By sach0025 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-10-2007, 01:07 AM
  5. Assignment overDUE PLEASE PLEASE HELP!!
    By undergrad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2006, 12:34 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