copy formula that contains time
 

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.

copy formula that contains time
 

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

copy formula that contains time
 

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" wrote:

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

copy formula that contains time
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"charlyx5" wrote:

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

copy formula that contains time
 

Max

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

Thanks
Charly H.

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"charlyx5" wrote:

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

copy formula that contains time
 

Welcome, Charly
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"charlyx5" wrote in message
...
Max

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

Thanks
Charly H.