title: Calculate hours between two times
body: <p>I am trying to calculate the hour between two times, for instance:</p>
  <p>actual time: 9:42:00 AM (by using today() formula)</p>
  <p>ending time: 05:00:00 PM</p>
  <p><strong>time left: 7:18</strong></p>
  <p>Having said that, I tried to use the formula today() in the actual time cell and then input manually the ending time. However it is giving me ####### as the output. I already changed for all the different date/time options and it is still appearing #####. Is there any other alternative way of calculating the time remaining?</p>