i got a data in polynominal format as HH:MM:SS.XXXXXX how to covert to time 24 hour format

alen4thomasalen4thomas Member Posts: 1 Newbie
in Help
the data set is given below.i just need to do a data cleaning for entire data.are there anything else to clean other tha the time
Jasmine_

Answers

  • kaymankayman Member Posts: 662 Unicorn
    The nominal to date operator allows you to convert your field to an actual date. Next you could use the date to nominal operator to change it back to the nominal format you prefer, or use the date options in the create attribute operator to tune it to any format you prefer. 
    Jasmine_
  • [Deleted User][Deleted User] Posts: 0 Learner III
    Hello

    If your data is in excel you can change it in excel then import it to RM.


    Regards
    mbs
    Jasmine_
Sign In or Register to comment.