Looking for FIFA World cup 2018 Tracker? Click here.
Today FIFA World-cup 2010 is beginning. For the next 30 days or so, no matter where you go, you are bound to hear about soccer, world cup, teams, points, goals and what not.
As a tribute to this beautiful and lovely sport, I want to showcase some really awesome excel spreadsheets that are designed to track FIFA Worldcup 2010. Follow the links and Enjoy.
Most Comprehensive and Awesomest FIFA Worldcup Tracker – by Graham
This is by far one of the most comprehensive and slickest Excel files on footbal that I have seen. The workbook can play national anthems of teams, show scores from past finals, has team ranks, automated scoring and much more. Just download and play with it. You are going to love it even if you are not a sucker for soccer.
FIFA Worldcup tracker from Excely – 2018
This one page spreadsheet can easily provide team points and help you track everything you want in one place.
Comprehensive World cup Tracker with Live Scores
This tracker can update scores from web. Very useful if you want to know where teams stand at any point. Also, this is very comprehensive and provides extensive analysis of matches, goals, shots etc.
A FIFA Worldcup Tracker from Microsoft
Another football world cup tracker / planner sheet with an added twist of ability to filter the team you want. Interesting stuff.
Worldcup Planner with team points
This is a straight forward tracker with option to track team points and calculate group standings. It uses macros, so enable them to get it work.
An Excel Tracker from Our Reader – Alan
Alan from Computer Gaga shares this excel tracker using which you can find group level standings, track scores and do so much more.
Well designed Excel Tracker and Planner
Another very well designed Excel based football tracker / planner. It doesn’t seem like an excel file, but more like a web page. Check it out.
One Page FIFA 2010 World cup Tracker from ExcelTemplate.net
One page tracker to keep track of scores and more.
Beautiful Flash based FIFA 2010 Calendar [non-excel]
![Beautiful Flash based FIFA 2010 Calendar [non-excel]](https://chandoo.org/img/2010/fifa-2010-planner-tracker-sheet-10.png){kind=tracking}
Ok, this is not an excel based thing, but it is very beautiful and easy to use. It is a flash based calendar with clear views of matches and scores by date, group, country.
FIFA Worldcup Excel Files on Chandoo.org
I have posted 2 workbooks related to FIFA worldcup on Chandoo.org. Check them out too,
- Looking for FIFA World cup 2018 Tracker? Click here.
- Balls used in FIFA Worldcup finals since 1930 – An Excel Chart
- FIFA Football Betting Sheet / Office Pool Template
Do you know any more excel based trackers / planners / wall charts for FIFA Worldcup 2010?
Please share using comments. I would love to see more excel files and learn from them.
Happy weekend 🙂
13 Responses to “Convert fractional Excel time to hours & minutes [Quick tip]”
Hi Purna..
Again a great tip.. Its a great way to convert Fractional Time..
By the way.. Excel has two great and rarely used formula..
=DOLLARFR(7.8,60) and =DOLLARDE(7.48,60)
basically US Account person uses those to convert some currency denomination.. and we can use it to convert Year(i.e 3.11 Year = 3 year 11 month) and Week(6.5 week = 6 week 5 days), in the same manner...
This doesn't work for me. When applying the custom format of [h]:mm to 7.8 I get 187:12
Any ideas why?
@Jason
7.8 in Excel talk means 7.8 days
=7.8*24
=187.2 Hrs
=187 Hrs 12 Mins
If you follow Chandoo's instructions you will see that he divides the 7.8 by 24 to get it to a fraction of a day
Simple, assuming the fractional time is in cell A1,
Use below steps to convert it to hours & minutes:
1. In the target cell, write =A1/24
2. Select the target cell and press CTRL+1 to format it (you can also right click and select format cells)
3. Select Custom from “Number” tab and enter the code [h]:mm
4. Done!
Hi, sorry to point this out but Column C Header is misspelt 'Hours Palyed'
good one
So how do I go the other way and get hours and minutes to fractional time?
If you have 7.5 in cell A1,
- Use int(A1) to get the hours.
- Use mod(A1,1)*60 to get minutes.
If you have 7:30 (formatted as time) in A1
- Use hours(a1) to get hours
- Use minutes(a1) to get minutes.
I had the same issue. You can solve it by changing the format as described above:
Right click cell > Format Cells > (In Number tab) > Custom > Then enter the code [h]:mm
([hh]:mm and [hhh]:mm are nice too if you want to show leading zeros)
Thanks guys, these are the tips I'm looking for.
...dividing the number of minutes elapsed by the percent change is my task - "int" is the key this time
It doesnt work for greater than 24 hours
It returns 1:30 for 25.5 hours. It should have returned 25:30
Ideally I would right function as
=QUOTIENT(A1,1)&":"&MOD(A1,1)*60
Sorry, replied to wrong comment....
----
I had the same issue. You can solve it by changing the format as described above:
Right click cell > Format Cells > (In Number tab) > Custom > Then enter the code [h]:mm
([hh]:mm and [hhh]:mm are nice too if you want to show leading zeros)
Clever use of MOD here to extract the decimal part of a number. Divide a number containing a decimal by 1 and return the remainder. Humm. Very clever.
Thanks very much, extremely useful !