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
Solved
AM PM to 24 Format
+6- Enthusiast
Best answer by david_r
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.
- Best Answer
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.
+6- Enthusiast
david_r wrote:
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.