ExcelBanter - Convert Time

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

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

- - Convert Time (https://www.excelbanter.com/excel-worksheet-functions/156939-convert-time.html)

Erika

Convert Time

I have a report that provides information in hour:minute:second format, for
example 1:30:20. How do I convert that to read as 90 minutes and 20 seconds?

Peo Sjoblom

Convert Time

Format as [mm]:ss

--
Regards,

Peo Sjoblom

"Erika" wrote in message
...
I have a report that provides information in hour:minute:second format, for
example 1:30:20. How do I convert that to read as 90 minutes and 20
seconds?

Erika

Convert Time

I can't believe it was that easy - perfect! Thank you so much for your help.

"Peo Sjoblom" wrote:

Format as [mm]:ss

--
Regards,

Peo Sjoblom

"Erika" wrote in message
...
I have a report that provides information in hour:minute:second format, for
example 1:30:20. How do I convert that to read as 90 minutes and 20
seconds?

All times are GMT +1. The time now is 01:17 PM.