Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Wilmington, North Carolina, USA
    Thanked 0 Times in 0 Posts

    Converting time/assigning values/I don't know?!? (Office XP)

    I want to do this: Default value is 100, default time is 18:00 (18 minutes). For every 10 seconds after 18:00, I.E. 18:01-18:10, I want the default value to go down 1. For any time before 18:00 (I.E. 17:59),I want the value to remain 100....any clues? Right now all I have is two cells, one for minutes, one for seconds, and then a formula....example attached.
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Salt Lake City, Utah, USA
    Thanked 6 Times in 6 Posts

    Re: Converting time/assigning values/I don't know?!? (Office XP)

    <P ID="edit" class=small>(Edited by JohnBF on 13-Dec-04 21:40. Corrected for the 18 minute minimum.)</P>If you mean that for each complete 10 seconds you want the value to decline (take off 1 for when it's in the range 10 - 19.99, take off 2 when it's in the range 20 -29.99, etc.), then this may be what you want:


    Depending on exactly how you want it to work, your original formula may be valid after adjustment, though it contained some redundant parentheses.


    (It would help if you label your columns.)
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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