Results 1 to 6 of 6

Thread: Frozen Pool Issue

  1. #1
    Location
    Canada
    Rep Power
    44

    Dobber Sports Veteran

    Default Frozen Pool Issue

    When I use the export to excel function for "Ice Time", I'm getting a weird issue and was just wondering if anyone knows how to fix it.

    The TOI shows in the cell as a numerical value (Ie. 26:54) which is how you would want to read it. However, the actual info pulling into the cell is coming in as a "date/time" instead of just a time or numerical value. ("1/1/1900 2:54:00 PM" instead of 26:54, or 11:55:00 PM instead of 23:55. Just 2 examples)

    My issue is when I try to use formula's that include the TOI cell, because of the format it's in the formula doesn't work.

    I've tried to re-format the cells a few different ways, but nothing seems to work.

    Any ideas?!?
    16 Team - Keep 5 - H2H Points
    Start: 2C/2LW/2RW/4D/2G - 4Bench
    G/A(1.25) STP(1.5) GWG(3) SOG(0.25) H(0.2) Blks(0.25) +/-(0.25) PIM(0.1) FOW(0.1)

    C: Malkin, Kopitar, Hartman, Johansen
    LW: Ovechkin, Pacioretty, Barbashev (C)
    RW: Rust, Mangiapane (LW), Rodrigues (LW)
    D: DeAngelo, Karlsson, Faulk, Morrisey, Myers
    G: A. Forsberg, Price, Reimer, Holtby

  2. #2
    Location
    Brampton, Ontario
    Rep Power
    40

    Dobber Sports Titan

    Default Re: Frozen Pool Issue

    Eric Daoust is out for the weekend, but he would be the one to contact about the issue.
    Associate Editor for DobberHockey (Wednesdays). Click that Ramblings button on the the menu bar!
    (No I don't have a hockey problem...)

  3. #3
    Location
    Canada
    Rep Power
    44

    Dobber Sports Veteran

    Default Re: Frozen Pool Issue

    Bump
    16 Team - Keep 5 - H2H Points
    Start: 2C/2LW/2RW/4D/2G - 4Bench
    G/A(1.25) STP(1.5) GWG(3) SOG(0.25) H(0.2) Blks(0.25) +/-(0.25) PIM(0.1) FOW(0.1)

    C: Malkin, Kopitar, Hartman, Johansen
    LW: Ovechkin, Pacioretty, Barbashev (C)
    RW: Rust, Mangiapane (LW), Rodrigues (LW)
    D: DeAngelo, Karlsson, Faulk, Morrisey, Myers
    G: A. Forsberg, Price, Reimer, Holtby

  4. #4
    Rep Power
    40

    Dobber Sports Supreme Grand Master

    Default Re: Frozen Pool Issue

    I know Eric Daoust is focusing his time on update and improving it... if you have direct concerns I would try PMing him.
    -------------------------------------------------------------------------------------------------------

    ​​

  5. #5
    JagrBomb's Avatar
    JagrBomb is offline
    Join Date
    Feb 2007
    Posts
    11,675
    Location
    toronto and ottaw
    Rep Power
    50

    Dobber Sports Juggernaut

    Default Re: Frozen Pool Issue

    Quote Originally Posted by saucelife90 View Post
    When I use the export to excel function for "Ice Time", I'm getting a weird issue and was just wondering if anyone knows how to fix it.

    The TOI shows in the cell as a numerical value (Ie. 26:54) which is how you would want to read it. However, the actual info pulling into the cell is coming in as a "date/time" instead of just a time or numerical value. ("1/1/1900 2:54:00 PM" instead of 26:54, or 11:55:00 PM instead of 23:55. Just 2 examples)

    My issue is when I try to use formula's that include the TOI cell, because of the format it's in the formula doesn't work.

    I've tried to re-format the cells a few different ways, but nothing seems to work.

    Any ideas?!?
    Until it's fixed you can just format the cell as follows:

    1. Select the column that contains the TOI
    2. Right click on any highlighted cell in that column, click on "Format Cells..."
    3. Select "Custom" Category
    4. In the text field under "Type", enter the following text: [h]:mm

    This should reformat that column and get rid of the trailing 00s

  6. #6
    Location
    Ontario
    Rep Power
    40

    Administrator

    Default Re: Frozen Pool Issue

    I forced it to format as text when read into Excel so now it displays the correct value. It's a bit more difficult to sort though. Try it out.


    Contact me for Frozen Tools bug reports and inquiries
    Follow Frozen Tools on Twitter @FrozenTools
    Follow me on Twitter @DH_EricDaoust

Posting Permissions

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