search

masterplane8 / F1-League-Management

F1 League Management is an Excel template designed to help F1 2021 league owners track points, penalties, and other league statistics.
26 stars 3 forks source link

Time from leader incorrect #27

Open Bloodspor7 opened 11 months ago

Bloodspor7 commented 11 months ago

I'm having issues with filling in the time from leader cell CC23. All the other cells are filled in correctly. But cell CC23 if i give a time from leader 33,940 it gives 2/02/1900 22:33:36. How to fix this ? Naamloos

masterplane8 commented 11 months ago

The easiest way to fix this is to highlight the two cells above, click and drag down on the small green square in the bottom right corner of the highlight so that it is dragged over the broken cell. This will fix the formatting issue. Another thing you can try to is to manually change the formatting back to General by right clicking on the cell and edit formatting.