if cell in column has a non-specific value, the copying value to another cell.

[Szucchari]

Hi,

I am trying to create a time sheet and I need some help.
in column B rows 1-4, if there are any times listed I need the time to pop up in cell B7. The time is not going to be specific.
There will only be 1 cell in the column that has the time listed in it.

I thought maybe and IF function but I dont have a specific criteria so I am not sure how to do it without one.

Thank you for your assistance.

 

[Larry Haydn]

Formula in cell B7:
=IF(B1<>0,B1,IF(B2<>0,B2,IF(B3<>0,B3,IF(B4<>0,B4,""))))

 

[Fluff]

How about
=LOOKUP(2,1/(B1:B4<>""),B1:B4)

or if you can have text values in some of those cells
=LOOKUP(2,1/(ISNUMBER(B1:B4)),B1:B4)