7 Replies Latest reply on Jan 11, 2017 7:00 PM by margaret.quigley

    Round Minutes in Time to Nearest Hour

    margaret.quigley

      Hello,

       

      We are collecting new rows of data from a social media API at every hour. Because the set is large, processing can take varying amounts of time. I'm plotting the changes in the data on an hourly basis in a workbook. Because some data is collected in the 50's of the hour but some data is collected in the first few minutes of the hour, two rows of data can be combined for one hour and skew the visual.

       

      Time Entered

      Post TypeTime Entered
      added_video9/10/16 9:03:25 AM
      added_video9/10/16 9:50:54 AM

       

      Does anyone know if it's possible to round to the nearest hour using a calculated field? The date / time field is [Time Entered].

       

      Thank you.