Results 1 to 3 of 3

Custom Text with Formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-01-2010
    Location
    Seattle, WA
    MS-Off Ver
    Excel:Mac 2003
    Posts
    1

    Custom Text with Formula

    Im trying to do the schedule at work, and what I want is:
    (attached is a picture of the cells)

    To be able to enter '4:00 PM' into cell B4, and have it show up as 'CL', but do the formula as if I had entered '4:00 PM', giving me the difference in hours in cell C4.

    But if I enter any other number than '4:00 PM', I do not want 'CL' to show up.

    How can I make this work?
    Thanks
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1