how to: if istime, display time, else display --

[riffraff]

Hi,

I am a cf programmer new to excel trying to build an app for a friend. on 1 sheet of the app, it lists all employees and lets you build a weekly work schedule for the employees entering times in cells like 9 a in one cell and 4 p in the next. the employees name is a hyperlink to another sheet in the same book that displays the employees weekly schedule in a cleaner format for printing. times display like 9:00 AM and 4:00 PM pulled from the first sheet using =TIMEVALUE(Schedule!M5).

My problem is, for the days an employee is not scheduled and no entry is made on the first sheet, i get #value! displaying in the cell on sheet 2 that references the first sheet.

again, im new to excel so i am hoping this is a matter of a simple if statement...

thanks in advance for any insight
riff

[Aladin Akyurek]

Try:

=IF(LEN(Schedule!M5),TIMEVALUE(Schedule!M5),"")

[riffraff]

thanks much for the quick reply, worked like a charm...

riff