Home / tip / Excel 2010 - Add times together (duration)

Excel 2010 - Add times together (duration)

Posted by Unknown Selasa, 19 November 2013 0 komentar

Introduction
I had a number of videos of varying duration. I wanted to find out if I watched all the videos one after another, how long they'd all take. I needed to sum the duration of the videos. At first I put the values in Excel in the format mm:ss (minute:second) but Excel didn't like that. I found that it works if you enter the times as hh:mm:ss (hour:minute:second).

Instructions

Enter the values hh:mm:ss - even if your values are shorter than one hour, as mine are, make sure you enter them as shown here with a preceding 00.

Select all the cells including an extra one, this will be the total.

Format the cells as Time (as shown in the above screen shot).

Click in the empty cell at the bottom and click AutoSum

You should end up with something similar to the following:

More help?

http://office.microsoft.com/en-001/excel-help/add-or-subtract-units-of-time-HP010070466.aspx

TERIMA KASIH ATAS KUNJUNGAN SAUDARA

Judul: Excel 2010 - Add times together (duration)
Ditulis oleh Unknown
Rating Blog 5 dari 5

Semoga artikel ini bermanfaat bagi saudara. Jika ingin mengutip, baik itu sebagian atau keseluruhan dari isi artikel ini harap menyertakan link dofollow ke http://apk-zippy.blogspot.com/2013/11/excel-2010-add-times-together-duration.html. Terima kasih sudah singgah membaca artikel ini.