title: In Microsoft Flow how do I grab an excel column and format as time for an email alert?
body: <p>I'm trying to use Microsoft Flow to watch a Sharepoint Excel document and send an email if a certain condition is true in a table. </p>
  
  <p>The email successfully contains the time column but the time looks like this: <code>0.569444444444444</code> rather than a nice formatted <code>13:40:00</code>.</p>
  
  <p>In my email alert this expression works to grab the value though it is formatted as 0.569444444444444... </p>
  
  <pre><code>item()?['Time Column']
  </code></pre>
  
  <p>When I read the documentation and try to format it nicely using this command however the Flow fails. </p>
  
  <pre><code>formatDateTime(item()?['Time Column'],'hh:mm:ss')
  </code></pre>
  
  <p>What am I doing wrong? Any advice? Thanks.</p>