Time into critera

[Legendkiller]

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?

[NBVC]

=A1/1440 gives how many days A1 minutes is equivalent to

[olasa]

Here is one option (see encl.)
HTH
Ola

[Legendkiller]

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

[olasa]

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

[Legendkiller]

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

[NBVC]

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.