Eric Daoust is out for the weekend, but he would be the one to contact about the 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
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...)
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
I know Eric Daoust is focusing his time on update and improving it... if you have direct concerns I would try PMing him.
-------------------------------------------------------------------------------------------------------
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
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