Forum Discussion

Sethlemley's avatar
Sethlemley
Copper Contributor
Feb 25, 2023

Time conversion

I'm trying to convert minutes:seconds into minutes ex. In cell A1 "2:45.72" which is 2 minutes and 45.72 seconds. I've tried the formula =MINUTE(A1)*60+SECOND(A1). But that returns a value of 166 it...
Formulas and Functions
Sethlemley's avatar
Sethlemley
Copper Contributor
Feb 25, 2023
Sorry I mistyped I want to convert to seconds not minutes.
  • FikturFox's avatar
    FikturFox
    Brass Contributor
    Feb 25, 2023
    A workaround:
    =MINUTE(A1)*60 + SECOND(A1) + RIGHT(TEXT(A1,"mm:ss.00"),3)*1

Resources