Convert Time

[Erika]

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]

Format as [mm]:ss

 

[Erika]

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

Format as [mm]:ss


--
Regards,

Peo Sjoblom

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?