On Sun, 29 May 2005 11:21:51 +0100, "Bob Phillips"
<phillips@tiscali.co.uk> wrote:

>If, and I accept that this might be a big If, all the non-time numbers are >
>1 you could use
>
>=SUMIF(A:A,"<=1")*24+SUMIF(A:A,">1")


thanks Bob, this works perfectly
I only have one question:
what those quotation marks do in this formula?

Mark