title: Running a formula in the background of a cell on Sheets
body: <p>I am trying to make a sheet where I can type a time (duration) into a cell without colons or decimals and it show up in the <strong>same</strong> cell with the colons and decimals (example: input &quot;10342&quot; and the cell reads &quot;1:03.42&quot;). The formula I have that works in another cell is:</p>
  <pre><code>=ARRAYFORMULA(TEXT(AVERAGE(VALUE(IF(D3&lt;&gt;&quot;&quot;, TEXT(
   IF(IFERROR(      LEFT(D3, LEN(D3)-6))=&quot;&quot;,      0,         LEFT(D3, LEN(D3)-6))&amp;&quot;:&quot;&amp;
   IF(IFERROR(RIGHT(LEFT(D3, LEN(D3)-4), 2))=&quot;&quot;, &quot;00&quot;, RIGHT(LEFT(D3, LEN(D3)-4), 2))&amp;&quot;:&quot;&amp; 
   IF(IFERROR(RIGHT(LEFT(D3, LEN(D3)-2), 2))=&quot;&quot;, &quot;00&quot;, RIGHT(LEFT(D3, LEN(D3)-2), 2))&amp;&quot;.&quot;&amp; 
   IF(LEN(D3)&gt;1, RIGHT(D3, 2), &quot;0&quot;&amp;D3), &quot;[h]:mm:ss.00&quot;), ))), &quot;[h]:mm:ss.00&quot;))
  </code></pre>
  <p>I have tried conditional formatting and I'm not the greatest with macros. Is there anyway that this would be possible?</p>