Results 1 to 2 of 2

Thread: List (03)

  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    List (03)

    I have a list box, that show the reporting time @ .5 (every 30 seconds) 1 minute, 5 minutes, etc. I need to calculate the rate charged based on those minutes. When I get down to 1 report per day or 1 report per week, or month, instead of showing the minutes (1440=1/day) I would just like to be able to show 1/day in the list box instead but still calculate using the 1440 (minutes). I have formated the minute cell as 0"=1/day" so that I can calculate. now if I could just show 1/day in the list box.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List (03)

    You could set the number format for the entire source range to the custom format

    <code>[=1440]"1/day";General</code>

Posting Permissions

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