Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,656
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    Try:

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

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    riff

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •