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
Page 1 / 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.
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