Forum Discussion
Solved
Issue with Excel Date/ Time to Power BI
Hi Sir, In excel- Column K (format: yyyy-mmm-dd hh:mm;@) Column L (format: yyyy-mmm-dd hh:mm;@) Column R ([h]:mm)= Column L - Column K Load power BI desktop and get data from the excel file...
"Number in excel is 1:50 but in power BI becomes 0.08."
Time data is stored as a decimal number between 0 and 1. 1 Hour is about 0.04166667 (1 over 24). 2 Hours is therefore 0.083333. So 1:50 would make sense being 0.08.
You should be able to instruct Power BI to attempt to recognise that as Time Data.
"Number in excel is 1:50 but in power BI becomes 0.08."
Time data is stored as a decimal number between 0 and 1. 1 Hour is about 0.04166667 (1 over 24). 2 Hours is therefore 0.083333. So 1:50 would make sense being 0.08.
You should be able to instruct Power BI to attempt to recognise that as Time Data.
how can i do that plzzzzz
i have the same issue and i can't see the solutions