| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy time from one page to another
I'm trying to setup a work schedule for my employees using time -Custom H:mm
am/pm I'm having a problem copying the schedule over to a second page. when the employee is off on one particular day - I leave the cell blank when it copies over it shows 12:00, I tried if then statement and that didn't work. can you help please... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy time from one page to another
Instead of: =Sheet1!B3
try it like this: =IF(Sheet1!B3="","",Sheet1!B3) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "charlyx5" wrote: I'm trying to setup a work schedule for my employees using time -Custom H:mm am/pm I'm having a problem copying the schedule over to a second page. when the employee is off on one particular day - I leave the cell blank when it copies over it shows 12:00, I tried if then statement and that didn't work. can you help please... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy time from one page to another
Thanks Max
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 "Max" wrote: Instead of: =Sheet1!B3 try it like this: =IF(Sheet1!B3="","",Sheet1!B3) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "charlyx5" wrote: I'm trying to setup a work schedule for my employees using time -Custom H:mm am/pm I'm having a problem copying the schedule over to a second page. when the employee is off on one particular day - I leave the cell blank when it copies over it shows 12:00, I tried if then statement and that didn't work. can you help please... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy time from one page to another
See response in your new posting
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPY A PAGE | Excel Worksheet Functions | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
| Excel-copy first row onto each page ok but not last page How? | Excel Discussion (Misc queries) | |||
| Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
Linear Mode
