| time | sub | add | interp | tosec | =$B$2&" "&TEXT($B$3,"MM/DD/YY")&", "&$C$3&": "&$F$4 | ||||||
| =ARGUMENT("big",1) | =ARGUMENT("arg1",1) | =ARGUMENT("arg1",1) | =ARGUMENT("arg1",1) | ||||||||
| =ARGUMENT("small",1) | =ARGUMENT("arg2",1) | =ARGUMENT("arg2",1) | =IF(arg1>=100,arg1-40,arg1) | ||||||||
| =ROUND(big-30,-2) | =ROUND(arg1-50,-2) | =ROUND(arg1-50,-2) | =RETURN(E3) | ||||||||
| =ROUND(small-30,-2) | =arg1-C4 | =arg1-D4 | |||||||||
| =big-B4 | =ROUND(arg2-50,-2) | ||||||||||
| =small-B5 | =arg2-C6 | =arg2-D6 | |||||||||
| =B4-B5 | =C4+C6 | =D4/100*60+D5 | |||||||||
| =B6-B7 | =C5+C7 | =D6/100*60+D7 | |||||||||
| =IF(B9<0,60+B9,B9) | =IF(C9>=60,C9-60,C9) | =(D8+D9)/2 | |||||||||
| =IF(B9<0,B8-100,B8) | =IF(C9>=60,C8+100,C8) | =ROUND(D10/60*100-50,-2) | |||||||||
| =B10+B11 | =C11+C10 | =((D10/60*100)-D11)/100*60 | |||||||||
| =RETURN(B12) | =RETURN(C12) | =ROUND(D11+D12,2) | |||||||||
| =RETURN(D13) | |||||||||||