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

riffraff

New Member
Joined
Apr 19, 2002
Messages
2
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
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top