Time for another quick Excel tip.
Lets say the park near your house rents tennis courts by hour. And they charge $10 per hour. At the end of an intense tennis playing week, Linda, the tennis court manager called you up and said you need to pay $78 as rent for that week.
How many hours did you play?
Of course 78/10 = 7.8 hours.
But we all know that 7.8 hours makes no sense.
We also know that 7.8 hours is really 7 hours 48 minutes.
So how to convert 7.8 hrs to 7:48 ?
That is our quick tip for the day.
Simple, assuming the fractional time is in cell A1,
Use below steps to convert it to hours & minutes:
- In the target cell, write =A1/24
- Select the target cell and press CTRL+1 to format it (you can also right click and select format cells)
- Select Custom from “Number” tab and enter the code [h]:mm
- Done!
52 Bonus tips:
Thats all for now. Stay awesome until next time.
12 Responses to “Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster”
A great tribute to one of the greatest batsmen's in Cricket history.
Thanks Chandoos!
A fantastic poster, Chandoo. I suspect most people would assume it was done in Adobe Illustrator.
Great work!
Daniel Ferry
excelhero.com/blog
[...] Visit his post to download the excel file: Sachin Tendulkar Statistics Excel Infographic Poster [...]
[...] Courtesy: Wikipedia.org >> Chandoo.org [...]
Please update the pingback url to http://www.newsilike.in/sachin-tendulkar-infographics/
Awesome man .....super work
[...] Wikipedia.org >> Chandoo.org ← Previous Next [...]
[...] Kummi in Blog, Dashboard, Excel, Infographic | No Comments Jan252012 Chandoo.org published an infographic poster created in Excel. As a big fan of Tendulkar, I really liked this [...]
[...] Via Tags: europe, football, european league, soccer, sports © 2012 Latest Infographics /* */ [...]
[...] Source [...]
[...] Link [...]
[…] Source […]