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

Instead of entering your data with the decimal point like: A B C 1) 1.20 2.40 3.10Enter 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:10Then 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

Thanks, that worked.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History