How to Convert 12 hours format to 24 hours format in Spotfire

[gurusai sankar]

Hi All,

i am getting resource timesheet updated data like below.

Input data: 1:30:00 PM

Expected Out put data: 13:30:00

How can i achive this

The reason for changing this format - I should show timsheet updated data

[Fabian Duerr]

There are probably many ways to do this filtering... But if you want to recalculate the entire date column then follow this (more general) transformation approach:

Go to 'insert' -> 'transformation' -> 'change data types' -> 'add' -> pick your date column -> 'Formatting' and there you can choose...

 

Or you go to the column properties and change the format the same way