My best guess:

Format as h:mm for a result of 0:45

=COUNTIF(A$1:A$6,"0")*TIME(0,15,0)

Format as GENERAL for a result of 45

=COUNTIF(A$1:A$6,"0")*15

Biff

"Paul" wrote in message
...
Hi I need to count cells in columns that have numbers in them. Can someone
help with formula please?
Example
1
0
3
5
0
0
i have maximum 48 rows in a column and i need the number of filled cells
multiplied by 15 minutes for each instance. In the above case it should
return 45 minutes. Help would be greatly appreciated.
Paul