Time Archive

  • A little while back a colleague of mine asked me, "How do I calculate the total seconds in Excel?" What he had was a column of timestamps in the h:mm:ss format and he wanted to convert that timestamps to simply display the total seconds, which is actually quite easy to do in Excel depending on (1) how the data was entered, and (2) how the data is formatted. Watch this video to learn how...

    Calculate Total Elapsed Seconds in Microsoft Excel 2010

    A little while back a colleague of mine asked me, "How do I calculate the total seconds in Excel?" What he had was a column of timestamps in the h:mm:ss format and he wanted to convert that timestamps to simply display the total seconds, which is actually quite easy to do in Excel depending on (1) how the data was entered, and (2) how the data is formatted. Watch this video to learn how...

    Continue Reading...