Try

=ROUND(TRIM(N(N21))*1440,0)/60



--
Regards,

Peo Sjoblom



"jeannie v" wrote in message
...
Hi Experts:

I know this is fundamental to formulas, but I'm doing something wrong..N20
returns #VALUE! if N21 is Blank......I want to it to state:

If Cell N21 is Blank, Insert 0:00:00

The existing formula that I want to add this statement to is:

=ROUND(TRIM(N21)*1440,0)/60

Can anyone help?
--
jeannie v