copy formula that contains time

[charlyx5]

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.

 

[Max]

Something like this, test/trap the error, then the blank:
=IF(ISERROR(Sheet1!B3),"",IF(Sheet1!B3="","",Sheet1!B3))

---

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

 

[charlyx5]

Max

That did not work
this is what I entered
=IF(ISERROR('2 Wk Schedule'!B8),"",IF('2 Wk Schedule'!B8="","",'2 Wk
Schedule'!B8))

Result 12:00 am
instead of 8.00

 

[Max]

The earlier was merely a link formula. It presumes that your formula
computing the 8 hours is in '2 Wk Schedule'!B8.

If that formula in '2 Wk Schedule'!B8 could also be returning a zero besides
a blank: "" or an error value, then think you could try:
=IF(ISERROR('2 Wk Schedule'!B8),"",IF(OR('2 Wk Schedule'!B8="",'2 Wk
Schedule'!B8=0),"",'2 Wk Schedule'!B8))

A zero will display as "12:00 am" when formatted as time

 

[charlyx5]

Max

That worked...I appreciate your assistance- great job.

Thanks
Charly H.

 

[Max]

Welcome, Charly