Time format into mm:ss retaining seconds value

[hechesspee]

Hi,
I'm looking to convert the below values in hh:mm:ss in to the fomart on the right.
Col hh:mm:ss--->Desired format
A1 01:57:00--->117.00
A2 01:18:00--->78.00
A3 00:32:30--->32.30
A4 00:05:38--->5.38
A5 00:28:10--->28.10

I used =A1*1440 and used numeric format with 2 decimal places. However it is converting the non-zero seconds part as below
117.00
78.00
32.50
5.63
28.17

Can someone advise me on how to get the desired format?

Thanks
HSP

 

[fhqwgads]

try custom format [m].ss

 

[hechesspee]

Thanks fhqwgads, it is not giving the right result.

Total duration in sec	hh:mm:ss	[m].ss
7020	01:57:00	168480.00
4680	01:18:00	112320.00
1950	00:32:30	46800.00
338	00:05:38	8112.00
1690	00:28:10	40560.00

 

[fhqwgads]

are you just typing 117 into the cell formatted with [m].ss?
it's reading that as a serial number date. day 117=117*24*60 minutes =168480
if you type in 01:57:00 it should return 117

 

[hechesspee]

Awesome, thanks for explaining. That works!