Solved Excel formula for tracking how many hours & minutes I read

June 22, 2012 at 17:33:32
Specs: Windows Vista
1.20 2.40 3.10 = 6.70 min. What formula would make it 7hr 10min
Ex. I read 1.20 (1 hour 20 min) on week 1, 2.40 (2hr 40min) on week 2 and 3.10 (3hr 10min) on week 3. This totals 6.70. What will convert this to 7.10 ? I am using Excel

See More: Excel formula for tracking how many hours & minutes I read

Report •


#1
June 22, 2012 at 19:03:35
✔ Best Answer
Instead of entering your data with the decimal point like:

    A       B       C
1) 1.20    2.40    3.10

Enter your data using the Colon, that tells Excel it's dealing with Time, so something like:

    A       B       C
1) 1:20    2:40    3:10

Then all you have to do is use the =SUM() function like:

=SUM(A1:C1) and you will get 7:10

See how that works.

MIKE

http://www.skeptic.com/


Report •

#2
June 22, 2012 at 19:50:53
Thanks, that worked.

Report •

Related Solutions


Ask Question