Remove or hide time when copy is blank

[debbiesh]

Hello all.

I have two worksheets - Managers and Employees - for tracking employees' time and tips while providing a printout of their weekly schedule. The times plugged into the Managers worksheet copy to the Employees worksheet. Times are formatted as h:mm AM/PM.

On the Managers sheet, A1 may have 10:00 AM and B1 may have 5:30 PM. But if the word OFF is in A1, then B1 is blank.

Problem: On the Employees worksheet, A1 will show the word OFF, but B1 will show 12:00 AM.

How can I get rid of worksheet showing 12:00 AM? I just want it to be blank unless it's an actual time.

Thanks for your help! Oh, I don't want to use macros unless it's unavoidable.

[Cutter]

Add a test to the formula by using an IF() function

like

=IF(ref cell="","",ref cell)

replace ref cell with actual cell address being referenced

[debbiesh]

Thanks! That's exactly what I needed.