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