Something like this, test/trap the error, then the blank:
=IF(ISERROR(Sheet1!B3),"",IF(Sheet1!B3="","",Sheet 1!B3))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"charlyx5" wrote:
How can I copy a formula that contains time HH/MM
formula calculates hours emp worked.
just need to copy it to another page without showing value.
how can I copy the formula for hours worked.
I just need to copy the result of the formula to another worksheet without
showing value or 12:00 ex...
8:15 AM
12:00 PM
12:30 PM
4:45 PM
8.00 I need to copy just 8.00