Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) |