Home > Software engineering >  Dynamically format duration in google sheets
Dynamically format duration in google sheets

Time:07-20

I want to input times that would be displayed in the formats below, depending on whether the digits are needed or not, like this.

s.mss
ss.mss
m:ss.mss
mm:ss.mss

My main problem is being able to use them to do math with (sum and subtraction only).

  • How could I do that?

Look at the enter image description here

Explanation

1 - Format the number in this case Date/Time with enter image description here

  • Related