What I am trying to do is search down a column of times that are in h:mm
format. All of the cells display a time even if I do not add a specific value
it shows 0:00 which I understand since I formatted the cells in this format
because it is necessary for this project. But what I want to do is search
this column for any time other than 0:00 and then write the value in the box
next to that cell in a seperate cell. any help would be appreciated. Thanks
Bill

Assume times in col A

Put in B1: =IF(A1=0,"",A1)
Format B1 as time
Copy down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Bill" wrote in message
...
What I am trying to do is search down a column of times that are in h:mm
format. All of the cells display a time even if I do not add a specific
value
it shows 0:00 which I understand since I formatted the cells in this
format
because it is necessary for this project. But what I want to do is search
this column for any time other than 0:00 and then write the value in the
box
next to that cell in a seperate cell. any help would be appreciated.
Thanks
Bill