Create new formula with the formula I provided earlier, you should end up with something like this:
![jthi_0-1653549256927.png jthi_0-1653549256927.png](https://community.jmp.com/t5/image/serverpage/image-id/42715iAC8D0D89164FF32A/image-size/medium?v=v2&px=400)
Then change the Format to what fits you best
![jthi_1-1653549295302.png jthi_1-1653549295302.png](https://community.jmp.com/t5/image/serverpage/image-id/42716i5A32086806209A3B/image-size/medium?v=v2&px=400)
You can do this in place, but I would suggest:
- Creating new formula column
- Changing Format
- Verifying everything works as you want to
- Deleting old column if you don't need it
- Renaming new column
If you have to do this often, then I would look into using JSL and scripting it (I think Activity Recorder/Enhanced Log in JMP16 can record all of these steps to make scripting very simple).
-Jarmo