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...