date time format
1 Topic
Date/time including ms
Hi All, I have a date time column where the raw data is decimal time in ecel format ie 45433.973275463 (which is 21/05/2024 13:00:27.19) In power bi I can not by defualt display the ms (.19 in the above example). As I need the column for some relationships and time intelligence i am forced to make a duplicate column and convert the decimal value into hh:mm:ss.00. Is there a simple way to do this? Thanks for your help. ChrisSolved1.2KViews0likes7Comments