fbpx
Search
Close this search box.

Best of Pointy Haired Dilbert – Nov 2008

Share

Facebook
Twitter
LinkedIn

best-of-phd-nov-2008November 2008 has been the best month since I started this blog and thanks to all the readers and commenters for your tremendous support.

We had 33 posts and 331 comments (highest ever). We also had 150,000 page views, 50% more than last month and highest ever. Our RSS subscriber base is now at 1750 and growing everyday. This is a great feeling and I couldn’t have done any of this without your constant support and motivation. I am thankful to each and everyone of you for helping me learn and share whatever I can.

Here is a list of best posts in November:

Support PHD:

If you enjoy the content featured here Share it with a friend or Bookmark this on Delicious or Stumble it!. It will make my day 🙂

You can keep up to date with PHD by subscribing to our RSS Feed or E-mail News Letter

Suggest:

Feel free to drop your suggestions, comments thru contact form in the About PHD page or email at chandoo.d at gmail.com. I *love* hearing from you 🙂

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

letter grades from test scores in Excel

How to convert test scores to letter grades in Excel?

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary formulas. I will also share a technique to calculate letter grades from test scores using percentiles.

4 Responses to “Best of Pointy Haired Dilbert – Nov 2008”

  1. Sumeet says:

    Hi Chandoo,

    I need a formula to convert secs to mins and also a formula to take a sum / average of those mins. For eg. 140 secs should display 2.2. I need a formula to calculate the sum of all the mins and also average of those mins.

  2. Chandoo says:

    @Sumeet: You can try a formula like: =int(secs/60)+(mod(secs,60)/100)

    to convert 140 secs to 2.2
    for averages, you may want to sum up all seconds and then divide by the total count and use the above formula again.

    Let me know if this doesnt help.

  3. Ketan says:

    @Chandoo :
    to convert the seconds into minuts only need to divide the seconds qty by 60
    In given example 140 sec = 2.2 minutes are wrong as 140 sec =2.3333 minutes
    For average and sum can be carried out as in normal practise.

  4. Sumeet says:

    Chandoo, I am satisfied with your answer. This is what I was looking for.

    Ketan, your answer 140 sec = 2.3 mins is incorrect as per me because I take 2.3 as 2 mins and 30 secs.

Leave a Reply