ExcelBanter - Changing number to mins/seconds

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

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

- - Changing number to mins/seconds (https://www.excelbanter.com/excel-worksheet-functions/250639-re-changing-number-mins-seconds.html)

Mike H

Changing number to mins/seconds

Katie,

Try this

=A1/(24*60*60)

Format as hh:mm:ss

Mike

"Katie" wrote:

I want to change data that is just a normal number into mins and seconds.
e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20
seconds

Katie.

All times are GMT +1. The time now is 05:22 PM.