Solved

AM PM to 24 Format

  • 27 March 2019
  • 2 replies
  • 16 views
J
Badge +1

Hi everyone,

I have attribute values like 7-10A, 6A-8P etc and I would like to convert them to 24 Hours format as in the following

  • 7-10A to 7-10
  • 6A-8P to 6-20
  • 10A-3P to 10-15

Any idea how i can do it? Many thanks

 

Best

icon

Best answer by david_r 27 March 2019, 16:59

View original

2 replies

david_r
Rank
Userlevel 4

I would consider using an AttributeSplitter followed by the DateTimeConverter. You can then join the start and end times back together in the end, if needed.

J
Badge +1

I would consider using an AttributeSplitter followed by the DateTimeConverter. You can then join the start and end times back together in the end, if needed.

DateTimeCoverter did not help or I could not figure out to use. I basically had to split by - and then try to convert to 24 i.e. Check if the sring is A, number stay as it is or if it is P, add 12 to the value

Reply


Community Stats

28,731
Posts
109,530
Replies
36,565
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.