The formula you've given us is valid. You haven't told us what's wrong with
the formula, and what results you are looking for.

TIMECALC is not integral to Excel. Is it some addon you are using? If so,
you need to explain what it does.

Regards,
Fred.

"Russmaz" wrote in message
...
I have the formula below

=IF(H9<0.0000001,IF(K9<0.000001,P9-E9,K9-E9),H9-E9)

I want to use the same formula but adapt it to TIMECALC
the formula is used with a funtion in a module on the spread sheet

as the data has been imported as text
cells H9 & K9 may or may not have data in
if not be ignored
If cell have no data in the totals to remain blank

Thanks
Russmaz