Visokio website     Downloads     Video tutorials     KnowledgeBase  
Time formatting Error - Visokio Forums
Time formatting Error
  •     TomW September 12, 2011 10:32AM
    Hi,

    I am currently trying to use the time format option within a Field Organiser with the format Hmm. However, I am using a 24 hour format at this is only picking up on any time prior to 10.00 or if it is 10.00 or 20.00 hours then it is converting to 1.00 and 2.00. When I use the HHmm format, it reads on everything above 10.00 but not below and I am missing a lot of times because of this.

    How am I able to get a format that allows me to have all of my cells filled correctly so I can have the correctly formatted dates for time series analysis?

    Thanks
  • 3 Comments
  •     steve September 12, 2011 11:08AM
    Please post a variety of dates in your supplied format.
  •     steve September 12, 2011 11:08AM
    And/or please attach a file (e.g. CSV) containing these dates.
  •     steve September 15, 2011 6:16AM
    As discussed over the phone - the null time values were caused by a combination of appends of blank cells, and converting values containing "Total" to dates.
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership