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

Would you use "Spotlight Search" on Windows?

Discuss in The Lounge

Poll History