ExcelBanter - Excel functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel functions (https://www.excelbanter.com/excel-worksheet-functions/236315-excel-functions.html)

How can I add up a column of times to give me a total expressed in hrs/mins
and secs

or alternatively simply convert a number into minutes and secs - ie 2.82 =
3m22sec ??

Use SUM() function and format the total cell to CustomFormat [h]:mm:ss

If this post helps click Yes
---------------
Jacob Skaria

"markwsquires" wrote:

How can I add up a column of times to give me a total expressed in hrs/mins
and secs

or alternatively simply convert a number into minutes and secs - ie 2.82 =
3m22sec ??

convert a number into minutes and secs - ie 2.82 = 3m22sec ??

What is the range of numbers you have?

A1 = 2.82

=TIME(0,INT(A1),MOD(A1,1)*100)

Format as m:ss returns 3:22

That won't work on anything greater than or equal to 60 minutes. For
example, 60.0 or 59.65.

--
Biff
Microsoft Excel MVP

"markwsquires" wrote in message
...
How can I add up a column of times to give me a total expressed in
hrs/mins
and secs

or alternatively simply convert a number into minutes and secs - ie 2.82 =
3m22sec ??