HI
I am having a OLAP cube and a standard measure which needs to be in hh:mm format. currently the number is coming in float. Guidance much appreciated.
Solved
Format standard measure to hh:mm format.
Best answer by Thomas Lind
Hi Jyothi
Just so everybody who reads this question knows it is possible to solve.
The solution to this is, you set up the format as hh:mm:ss. You cant find it in the list, but manually typing it in will work.
Before you us this, you need to divide your measure with a fraction of a day. So Seconds is 86400 (60*60*24), minutes is 1440 (60*24) and hours is 24.
+5Hi Jyothi
Just so everybody who reads this question knows it is possible to solve.
The solution to this is, you set up the format as hh:mm:ss. You cant find it in the list, but manually typing it in will work.
Before you us this, you need to divide your measure with a fraction of a day. So Seconds is 86400 (60*60*24), minutes is 1440 (60*24) and hours is 24.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
