Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Promoted
How do I tell excel to sum up units as hours?
Ex. I have columns with the numbers 2 3 5 6 8 8 8. 1 unit equals 15 minutes. The total of the numbers above would be 10 hours. I need the formula that can calculate that for me.
1 Answer
Relevance
- jmorgeLv 61 decade agoFavorite Answer
since 1 unit is the equivalent of a quarter hour, just multiply everything by .25. So 2+3+5+6+8+8+8=40 X .25 = 10 hours
Still have questions? Get your answers by asking now.