Forum Discussion
Solved
DEcimal to Time format
How to convert decimal to time format? I searched in all the queries however i dont see the same scenario as mine. Ex. 9:00 converted in decimal by Power BI is 0.375. Now how can i convert 0.365 ...
Try this:
Measure = VAR time = SUM(Summary[NewLoginTime])/Summary[EmployeeName Count]) VAR hours = ROUNDDOWN(24 * time ; 0) VAR H_rem = 24 * time - ROUNDDOWN(24 * time ; 0) VAR minutes = ROUNDDOWN(60 * H_rem ; 0) VAR M_rem = 60 * H_rem - ROUNDDOWN(60 * H_rem ; 0) VAR seconds = ROUND(60 * M_rem ; 0) Return TIME(hours;minutes;seconds)
Remember to also change the format to HH:MM:SS:
MartynRamsden
Solution Sage
Solution SageHi joyce23
If you have the decimal value in a column, it should just be a case of changing the column Data type.
Go to the Data view, the select the Column tools menu.
Column Data type = Decimal number:
Column Data type = Time:
Best regards,
Martyn
If I answered your question, please help others by accepting it as a solution.