filter list of times Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If you have a list of times eg:
00:00
00:15
00:30
00:45
01:00
etc, how can you sort them so you can only see those ending in 0? Have
tried a range of filters and also an IF statement, but format keeps showing
full hh:mm:ss in formula bar when I do either of these, despite having set up
a custom format for hh:mm, which still shows as cell format in Format Cell
menu. Any help much appreciated
 
In a helper column enter the formula:

=IF(ROUND(A3/"00:10",0)*"00:10"=A3,1,0)
and copy down. Then filter on 1

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Alternative returning TRUE/FALSE

=ROUND(MINUTE(A3)/2,0)*2=MINUTE(A3)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Bob Phillips said:
Alternative returning TRUE/FALSE

=ROUND(MINUTE(A3)/2,0)*2=MINUTE(A3)
Click to expand...
Except that 0:16 would trurn TRUE whereas the OP only wants time ending in 0

--
Regards

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top