View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default filter list of times Excel 2003

"Bob Phillips" wrote in message
...
Alternative returning TRUE/FALSE

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

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


Replace @mailinator.com with @tiscali.co.uk