{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Examples","Test Cases"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Examples","index":0,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["01:25.89","<- Try editing this box, enter a time as 'MM:SS.00 or 'MM.00"]
[{"$f":"IFERROR((IFERROR(LEFT(A1,FIND(\":\",A1)-1)* 60,0) ) + RIGHT(A1,LEN(A1)-FIND(\":\",A1)),VALUE(A1))","v":85.89},"<- Result when converted to decimal seconds using built-in Excel functions"]
[{"$f":"MMSSHH2dec(A1)","v":85.89},"<- Result when converted to decimal seconds using VB code"]
[{"$f":"dec2MMSSHH(A2)","v":"1:25.89"},"<- Easy to convert back to a 'MM:SS.00 text string"]
[]
[0.25,"<- Try editing this box"]
[{"$f":"FLOOR(A3,A6)","v":85.75},"<- how about rounding our time down to the nearest 0.25 seconds"]
[{"$f":"dec2MMSSHH(A7)","v":"1:25.75"},"<- Lets see that in MM:SS.00"]
[{"$f":"CEILING(A3,A6)","v":86},"<- or rounding it up to nearest 0.25 seconds"]
[{"$f":"dec2MMSSHH(A9)","v":"1:26.00"},"<- Lets see that in MM:SS.00"]
[]
[1.05,"<- Try editing this box"]
[{"$f":"A3*A12","v":90.1845},"<- how about changing it by a % "]
[{"$f":"dec2MMSSHH(A13)","v":"1:30.18"},"<- Lets see that in MM:SS.00"]
[]
["9:00.00","<- Try editing this box"]
["15:28.11","<- Try editing this box"]
[{"$f":"MMSSHH2dec(A17)-MMSSHH2dec(A16)","v":388.11},"<- difference between two times in seconds"]
[{"$f":"dec2MMSSHH(A18)","v":"6:28.11"},"<- Lets see that in MM:SS.00"]
[]
[null,"Until Excel supports times in MM:SS.00 properly this is all much easier with decimal seconds that excel is good at working with"]
[null,"Just remember to use text strings for your times, the leading half quote forces this e.g. '30.25 or '1:25.87"]
[null,"Have a look at the Test Cases sheet to see how =MMSSHH2dec() handles poorly formated input."]

{"sheet":"Test Cases","index":1,"n_rows":115,"n_cols":7,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
["Conversion of 'MM:SS.00' string in to a decimal time in seconds and vice-versa."]
[]
["Test cases - see below for tests of legal and illegal inputs, range checking and to compare the results from the two methods"]
[]
["Result 1","Converts MM:SS.00 to decimal using normal excel functions"]
[null,"The formula for Result 1 is =IFERROR((IFERROR(LEFT(A1,FIND(\":\",A1)-1)* 60,0) ) + RIGHT(A1,LEN(A1)-FIND(\":\",A1)),VALUE(A1))"]
[null,"Change ALL the 'A1' to your chosen cell!"]
[null,"Overall for a quick and dirty method it is not bad, however it is a PITA to change the Cell location because of how many times it is used"]
[null,"The two biggest problems with this method are  "]
[null,"1) HH.MM.SS format which the Sportsystems SC->LC conversion emits"]
[null,"2) It does not trap seconds over 59 in MM:SS.00 which could allow odd times through"]
[]
["Result 2","Converts MM:SS.00 to decimal using VB function "]
[null,"Written by Mark Leman for Kent Swimming  "]
[null,"This is much easier to use, just a simple =MMSSHH2dec(A1)"]
[]
[" MM:SS.00 Test Time in Text","Expected result ","Result 1","Result 2","Convert back to MM:SS.00 ",null,"Notes"]
[null,null,{"$f":"IFERROR((IFERROR(LEFT(A18,FIND(\":\",A18)-1)* 60,0) ) + RIGHT(A18,LEN(A18)-FIND(\":\",A18)),VALUE(A18))","v":0},{"$f":"MMSSHH2dec(A18)","v":""},{"$f":"dec2MMSSHH(D18)","v":""},null,"Should an Empty cell return 0 or \"\", it is easy to change the code to return either "]
[null,null,null,"",""]
[0,0,{"$f":"IFERROR((IFERROR(LEFT(A20,FIND(\":\",A20)-1)* 60,0) ) + RIGHT(A20,LEN(A20)-FIND(\":\",A20)),VALUE(A20))","v":0},0,"00.00",null,"Simple integer numbers should probably be retuned as second"]
["1",1,1,1,"01.00",null,"Simple integer numbers should probably be retuned as second"]
["2",2,2,2,"02.00",null,"Simple integer numbers should probably be retuned as second"]
["99",99,99,99,"1:39.00",null,"Simple integer numbers should probably be retuned as second"]
["100",100,100,100,"1:40.00",null,"Simple integer numbers should probably be retuned as second"]
[101,"#VALUE",101,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,"",""]
["0.00",0,{"$f":"IFERROR((IFERROR(LEFT(A27,FIND(\":\",A27)-1)* 60,0) ) + RIGHT(A27,LEN(A27)-FIND(\":\",A27)),VALUE(A27))","v":0},0,"00.00",null,"Properly formatted time with just S.00"]
["0.11",0.11,{"$f":"IFERROR((IFERROR(LEFT(A28,FIND(\":\",A28)-1)* 60,0) ) + RIGHT(A28,LEN(A28)-FIND(\":\",A28)),VALUE(A28))","v":0.11},0.11,"00.11",null,"Properly formatted time with just S.00"]
["1.22",1.22,{"$f":"IFERROR((IFERROR(LEFT(A29,FIND(\":\",A29)-1)* 60,0) ) + RIGHT(A29,LEN(A29)-FIND(\":\",A29)),VALUE(A29))","v":1.22},1.22,"01.22",null,"Properly formatted time with just S.00"]
["9.99",9.99,{"$f":"IFERROR((IFERROR(LEFT(A30,FIND(\":\",A30)-1)* 60,0) ) + RIGHT(A30,LEN(A30)-FIND(\":\",A30)),VALUE(A30))","v":9.99},9.99,"09.99",null,"Properly formatted time with just S.00"]
[null,null,null,"",""]
["00.00",0,{"$f":"IFERROR((IFERROR(LEFT(A32,FIND(\":\",A32)-1)* 60,0) ) + RIGHT(A32,LEN(A32)-FIND(\":\",A32)),VALUE(A32))","v":0},0,"00.00",null,"Properly formatted time with just SS.00"]
["00.99",0.99,0.99,0.99,"00.99",null,"Properly formatted time with just SS.00"]
["10.55",10.55,10.55,10.55,"10.55",null,"Properly formatted time with just SS.00"]
["45.67",45.67,45.67,45.67,"45.67",null,"Properly formatted time with just SS.00"]
["59.99",59.99,59.99,59.99,"59.99",null,"Properly formatted time with just SS.00"]
["60.00",60,60,60,"60.00",null,"Properly formatted time with just SS.00 - sometimes coaches will use seconds over a minute "]
["70.59",70.59,70.59,70.59,"1:10.59",null,"Properly formatted time with just SS.00 - sometimes coaches will use seconds over a minute "]
["99.99",99.99,99.99,99.99,"1:39.99",null,"Properly formatted time with just SS.00 - sometimes coaches will use seconds over a minute "]
["100.00",100,100,100,"1:40.00",null,"Test of SSS.00"]
["100.99",100.99,100.99,100.99,"1:40.99",null,"How far should we go? Currently limit to SS <=100 seconds, so 100.99 should work but 101.00 should be rejected"]
["101.00","#VALUE",101,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"How far should we go? Currently limit to SS <=100 seconds, so 100.99 should work but 101.00 should be rejected"]
[null,null,null,"",""]
["0:00.00",0,{"$f":"IFERROR((IFERROR(LEFT(A44,FIND(\":\",A44)-1)* 60,0) ) + RIGHT(A44,LEN(A44)-FIND(\":\",A44)),VALUE(A44))","v":0},0,"00.00",null,"Properly formatted time with M:SS.00"]
["1:00.00",60,60,60,"60.00",null,"Properly formatted time with M:SS.00"]
["1:00.99",60.99,60.99,60.99,"1:00.99",null,"Properly formatted time with M:SS.00"]
["1:20.75",80.75,80.75,80.75,"1:20.75",null,"Properly formatted time with M:SS.00"]
["1:59.99",119.99,119.99000000000001,119.99,"1:59.99",null,"Properly formatted time with M:SS.00"]
["2:00.00",120,120,120,"2:00.00",null,"Properly formatted time with M:SS.00"]
["9:59.99",599.99,599.99,599.99,"9:59.99",null,"Properly formatted time with M:SS.00"]
[null,null,null,"",""]
["00:00.00",0,{"$f":"IFERROR((IFERROR(LEFT(A52,FIND(\":\",A52)-1)* 60,0) ) + RIGHT(A52,LEN(A52)-FIND(\":\",A52)),VALUE(A52))","v":0},0,"00.00",null,"Properly formatted time with MM:SS.00"]
["10:00.50",600.5,{"$f":"IFERROR((IFERROR(LEFT(A53,FIND(\":\",A53)-1)* 60,0) ) + RIGHT(A53,LEN(A53)-FIND(\":\",A53)),VALUE(A53))","v":600.5},600.5,"10:00.50",null,"Properly formatted time with MM:SS.00"]
["10:20.75",620.75,{"$f":"IFERROR((IFERROR(LEFT(A54,FIND(\":\",A54)-1)* 60,0) ) + RIGHT(A54,LEN(A54)-FIND(\":\",A54)),VALUE(A54))","v":620.75},620.75,"10:20.75",null,"Properly formatted time with MM:SS.00"]
["99:59.99",5999.99,{"$f":"IFERROR((IFERROR(LEFT(A55,FIND(\":\",A55)-1)* 60,0) ) + RIGHT(A55,LEN(A55)-FIND(\":\",A55)),VALUE(A55))","v":5999.99},5999.99,"99:59.99",null,"Properly formatted time with MM:SS.00"]
["999:59.99",59999.99,{"$f":"IFERROR((IFERROR(LEFT(A56,FIND(\":\",A56)-1)* 60,0) ) + RIGHT(A56,LEN(A56)-FIND(\":\",A56)),VALUE(A56))","v":59999.99},59999.99,"999:59.99",null,"At the moment I have decided to limit the string length 9 chars so this is the biggest 'properly' formatted input "]
[]
["Test of Zeros with odd formatting",null,null,null,{"$f":"dec2MMSSHH(D58)","v":""}]
["0",0,{"$f":"IFERROR((IFERROR(LEFT(A59,FIND(\":\",A59)-1)* 60,0) ) + RIGHT(A59,LEN(A59)-FIND(\":\",A59)),VALUE(A59))","v":0},{"$f":"MMSSHH2dec(A59)","v":0},"00.00",null,"Zero is Zero :-)"]
["0.0",0,{"$f":"IFERROR((IFERROR(LEFT(A60,FIND(\":\",A60)-1)* 60,0) ) + RIGHT(A60,LEN(A60)-FIND(\":\",A60)),VALUE(A60))","v":0},0,"00.00",null,"And so is 0.0"]
["0:00",0,{"$f":"IFERROR((IFERROR(LEFT(A61,FIND(\":\",A61)-1)* 60,0) ) + RIGHT(A61,LEN(A61)-FIND(\":\",A61)),VALUE(A61))","v":0},0,"00.00",null,"And so is 0:0"]
[":00.00",0,{"$f":"IFERROR((IFERROR(LEFT(A62,FIND(\":\",A62)-1)* 60,0) ) + RIGHT(A62,LEN(A62)-FIND(\":\",A62)),VALUE(A62))","v":0},0,"00.00",null,"Looks like a zero to me"]
["0:0.0",0,{"$f":"IFERROR((IFERROR(LEFT(A63,FIND(\":\",A63)-1)* 60,0) ) + RIGHT(A63,LEN(A63)-FIND(\":\",A63)),VALUE(A63))","v":0},0,"00.00",null,"How many more ways to miss-format a zero"]
[null,null,null,"",""]
["Test odd cases: seconds with single digit hundredths - these could easily be trapped but at the moment that are treated as tenths",null,null,null,""]
["1.0",1,{"$f":"IFERROR((IFERROR(LEFT(A66,FIND(\":\",A66)-1)* 60,0) ) + RIGHT(A66,LEN(A66)-FIND(\":\",A66)),VALUE(A66))","v":1},{"$f":"MMSSHH2dec(A66)","v":1},"01.00",null,"Should probably handle this as 1 second and 1 tenth = 10 hundredths, becomes 1.0"]
["9.9",9.9,{"$f":"IFERROR((IFERROR(LEFT(A67,FIND(\":\",A67)-1)* 60,0) ) + RIGHT(A67,LEN(A67)-FIND(\":\",A67)),VALUE(A67))","v":9.9},{"$f":"MMSSHH2dec(A67)","v":9.9},"09.90",null,"And this is 9.90"]
[null,null,null,{"$f":"MMSSHH2dec(A68)","v":""},""]
["Test odd cases: Minutes with single digit seconds - this might actually be a good thing to reject but at the moment they are assumed to be seconds.",null,null,null,""]
["1:0",60,{"$f":"IFERROR((IFERROR(LEFT(A70,FIND(\":\",A70)-1)* 60,0) ) + RIGHT(A70,LEN(A70)-FIND(\":\",A70)),VALUE(A70))","v":60},{"$f":"MMSSHH2dec(A70)","v":60},"60.00",null,"Should probably handle this as 1Min 0 seconds"]
["1:5",65,{"$f":"IFERROR((IFERROR(LEFT(A71,FIND(\":\",A71)-1)* 60,0) ) + RIGHT(A71,LEN(A71)-FIND(\":\",A71)),VALUE(A71))","v":65},65,"1:05.00",null,"Should this be M:S? and if so is it 1min 5sec or 1min 50sec"]
[null,null,null,"",""]
["1:00",60,{"$f":"IFERROR((IFERROR(LEFT(A73,FIND(\":\",A73)-1)* 60,0) ) + RIGHT(A73,LEN(A73)-FIND(\":\",A73)),VALUE(A73))","v":60},60,"60.00",null,"Should handle this as M:SS missing the .00"]
["9:59",599,{"$f":"IFERROR((IFERROR(LEFT(A74,FIND(\":\",A74)-1)* 60,0) ) + RIGHT(A74,LEN(A74)-FIND(\":\",A74)),VALUE(A74))","v":599},599,"9:59.00",null,"Should handle this as M:SS missing the .00"]
["59:59",3599,{"$f":"IFERROR((IFERROR(LEFT(A75,FIND(\":\",A75)-1)* 60,0) ) + RIGHT(A75,LEN(A75)-FIND(\":\",A75)),VALUE(A75))","v":3599},3599,"59:59.00",null,"Should handle this as MM:SS missing the .00"]
["65:55",3955,{"$f":"IFERROR((IFERROR(LEFT(A76,FIND(\":\",A76)-1)* 60,0) ) + RIGHT(A76,LEN(A76)-FIND(\":\",A76)),VALUE(A76))","v":3955},3955,"65:55.00"]
[null,null,null,"",""]
["1:10.5",70.5,{"$f":"IFERROR((IFERROR(LEFT(A78,FIND(\":\",A78)-1)* 60,0) ) + RIGHT(A78,LEN(A78)-FIND(\":\",A78)),VALUE(A78))","v":70.5},70.5,"1:10.50",null,"Should handle this as MM:SS.0"]
["10:0.5",600.5,{"$f":"IFERROR((IFERROR(LEFT(A79,FIND(\":\",A79)-1)* 60,0) ) + RIGHT(A79,LEN(A79)-FIND(\":\",A79)),VALUE(A79))","v":600.5},600.5,"10:00.50",null,"Should probably handle this as 10min 0.5 seconds"]
[null,null,null,"",""]
["Odd delimiters",null,null,null,""]
["1.20.99",80.989999999999995,{"$f":"IFERROR((IFERROR(LEFT(A82,FIND(\":\",A82)-1)* 60,0) ) + RIGHT(A82,LEN(A82)-FIND(\":\",A82)),VALUE(A82))","v":{"$error":"#VALUE!"}},{"$f":"MMSSHH2dec(A82)","v":80.989999999999995},"1:20.99",null,"Sports systems SC->LC converter gives results with MM.SS.00, using a '.' between MM and SS rather than a ':', would be good to accept this too"]
["1:20:99",80.989999999999995,{"$f":"IFERROR((IFERROR(LEFT(A83,FIND(\":\",A83)-1)* 60,0) ) + RIGHT(A83,LEN(A83)-FIND(\":\",A83)),VALUE(A83))","v":60.90208333333333},{"$f":"MMSSHH2dec(A83)","v":80.989999999999995},"1:20.99",null,"Conversely should we accept and process MM:SS:00 ?"]
["1.20:99",80.989999999999995,{"$f":"IFERROR((IFERROR(LEFT(A84,FIND(\":\",A84)-1)* 60,0) ) + RIGHT(A84,LEN(A84)-FIND(\":\",A84)),VALUE(A84))","v":171},{"$f":"MMSSHH2dec(A84)","v":80.989999999999995},"1:20.99",null,"Should we accept this miss formatted input?"]
[null,null,null,{"$f":"MMSSHH2dec(A85)","v":""},""]
["Too many seconds",null,null,null,""]
["1:60.00","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A87,FIND(\":\",A87)-1)* 60,0) ) + RIGHT(A87,LEN(A87)-FIND(\":\",A87)),VALUE(A87))","v":120},{"$f":"MMSSHH2dec(A87)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"Times with MM should only accept seconds 00->59 "]
["1:99.00","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A88,FIND(\":\",A88)-1)* 60,0) ) + RIGHT(A88,LEN(A88)-FIND(\":\",A88)),VALUE(A88))","v":159},{"$f":"MMSSHH2dec(A88)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"Times with MM should only accept seconds 00->59 "]
["1:100.59","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A89,FIND(\":\",A89)-1)* 60,0) ) + RIGHT(A89,LEN(A89)-FIND(\":\",A89)),VALUE(A89))","v":160.59},{"$f":"MMSSHH2dec(A89)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"Times with MM should only accept seconds 00->59 "]
["1:1234","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A90,FIND(\":\",A90)-1)* 60,0) ) + RIGHT(A90,LEN(A90)-FIND(\":\",A90)),VALUE(A90))","v":1294},{"$f":"MMSSHH2dec(A90)","v":{"$error":"#VALUE!"}},{"$f":"dec2MMSSHH(D90)","v":{"$error":"#VALUE!"}},null,"Times with MM should only accept seconds 00->59 "]
[null,null,null,{"$f":"MMSSHH2dec(A91)","v":""},""]
["Big values",null,null,null,""]
["999:59.99",59999.99,{"$f":"IFERROR((IFERROR(LEFT(A93,FIND(\":\",A93)-1)* 60,0) ) + RIGHT(A93,LEN(A93)-FIND(\":\",A93)),VALUE(A93))","v":59999.99},{"$f":"MMSSHH2dec(A93)","v":59999.99},"999:59.99",null,"Largest accepted MMM:SS.00"]
["1000:00.00","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A94,FIND(\":\",A94)-1)* 60,0) ) + RIGHT(A94,LEN(A94)-FIND(\":\",A94)),VALUE(A94))","v":60000},{"$f":"MMSSHH2dec(A94)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"Decided to limit MM to 999 (this actually get rejected by the string limit on 9 chars)"]
["1000:00","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A95,FIND(\":\",A95)-1)* 60,0) ) + RIGHT(A95,LEN(A95)-FIND(\":\",A95)),VALUE(A95))","v":60000},{"$f":"MMSSHH2dec(A95)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"No you can't sneak past the 999 limit with a shorter string"]
[null,null,null,{"$f":"MMSSHH2dec(A96)","v":""},""]
["More Odd delimiters",null,null,null,""]
[".25",0.25,{"$f":"IFERROR((IFERROR(LEFT(A98,FIND(\":\",A98)-1)* 60,0) ) + RIGHT(A98,LEN(A98)-FIND(\":\",A98)),VALUE(A98))","v":0.25},{"$f":"MMSSHH2dec(A98)","v":0.25},"00.25",null,"0.25 of a second"]
[".2",0.2,0.2,0.2,"00.20",null,".2 of a second"]
["10:",600,0.41666666666666669,600,"10:00.00",null,"10 mins (method 1 really mucks this one up!)"]
[":.","#VALUE",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"Really not valid but could return zero?"]
[":.0",0,0,0,"00.00",null,"0 hundredths"]
[":.05",0.05,0.05,0.05,"00.05",null,"5 hundredths"]
[":.2",0.2,0.2,0.2,"00.20",null,"20 hundredths "]
[":.25",0.25,0.25,0.25,"00.25",null,"25 hundredths"]
[null,null,null,"",""]
["Test of leading and trailing spaces being stripped",null,null,null,""]
["      99:59.99",5999.99,{"$f":"IFERROR((IFERROR(LEFT(A108,FIND(\":\",A108)-1)* 60,0) ) + RIGHT(A108,LEN(A108)-FIND(\":\",A108)),VALUE(A108))","v":5999.99},{"$f":"MMSSHH2dec(A108)","v":5999.99},"99:59.99",null,"You can't see the leading spaces unless you click on the cell"]
["99:59.99      ",5999.99,{"$f":"IFERROR((IFERROR(LEFT(A109,FIND(\":\",A109)-1)* 60,0) ) + RIGHT(A109,LEN(A109)-FIND(\":\",A109)),VALUE(A109))","v":5999.99},{"$f":"MMSSHH2dec(A109)","v":5999.99},"99:59.99",null,"Trailing spaces are visible in a right justified cell"]
[null,null,null,{"$f":"MMSSHH2dec(A110)","v":""},""]
["Test of illegal chars",null,null,null,""]
["abcd","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A112,FIND(\":\",A112)-1)* 60,0) ) + RIGHT(A112,LEN(A112)-FIND(\":\",A112)),VALUE(A112))","v":{"$error":"#VALUE!"}},{"$f":"MMSSHH2dec(A112)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"Only allowed \"0-9: .\" in string "]
["OO:11:33","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A113,FIND(\":\",A113)-1)* 60,0) ) + RIGHT(A113,LEN(A113)-FIND(\":\",A113)),VALUE(A113))","v":0.48125000000000001},{"$f":"MMSSHH2dec(A113)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"The '00' is letter O"]
["oo:11:33","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A114,FIND(\":\",A114)-1)* 60,0) ) + RIGHT(A114,LEN(A114)-FIND(\":\",A114)),VALUE(A114))","v":0.48125000000000001},{"$f":"MMSSHH2dec(A114)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,"The '00' is letter O"]
["12,12,12","#VALUE",{"$f":"IFERROR((IFERROR(LEFT(A115,FIND(\":\",A115)-1)* 60,0) ) + RIGHT(A115,LEN(A115)-FIND(\":\",A115)),VALUE(A115))","v":{"$error":"#VALUE!"}},{"$f":"MMSSHH2dec(A115)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]