+ Reply to Thread
Results 1 to 2 of 2

Change TimeValue to reference a Cell entered value instead

  1. #1
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Change TimeValue to reference a Cell entered value instead

    Please Login or Register  to view this content.

    I cannot seem to get the correct method for the above to work, instead of hard coding the set time in hh:mm:ss.

    Am i missing something obvious ?

    What do i set the cell format to hh:mm:ss or number etc ?

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Change TimeValue to reference a Cell entered value instead

    Untested.
    Try changing .Value to .Text
    Last edited by WasWodge; 04-09-2013 at 03:39 AM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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