Search code examples
google-sheetstimesumformattingduration

Total Time from MM:SS.SSS format

I want to get total time of two in google spreadsheet t1 = 0:57.667 t2 = 01:01.112

Both t1 and t2 format to MM:SS.SSS

When I try to add them with sum(t1;t2) get: 0:00.000 even if it is format to MM:SS.SSS

When I try to add them with t1+t2 get: „0:57.667“ is text and can`t be changed to number.

Any solution to this problem?

Solution

  • use:

    =INDEX(TEXT(SUM(VALUE("00:"&A1:A2)); "[mm]:ss.000"))

    enter image description here