```I'm using this metric format, when the hours ar...
# gd-beginners
t
Copy code
I'm using this metric format, when the hours are above 24 it counts the days.
I wish you didn't count the days. type is 30:10:00
i.e. 30 hours, 10 min and 00 seconds.
{{{24||[>1]# Days\, ; [>0]# Days\, ; #}}}{{{|24|0}}}:{{{0.016666666|60.|00}}} Hours
m
Hi Tomas, thank you for contacting us. First, I would like to clarify which of our products are you using, GoodData Cloud or Platform?
t
I'm using it here in metric format
Hi, I have no answers.
m
Hi Tomas, my apologies. I can see you are using Platform. Can you provide us an example of the format of the metric/fact HoraContratadas, please?
t
Currently I use the format {{{24||[>1]# Days\, ; [>0]# Days\, ; #}}}{{{|24|0}}}:{{{0.016666666|60.|00}}} Hours he brings me 02 Days 041000 Hours. every 24h is counting 1 day. I'm trying to create something to bring the total hours. following the example above, you would have to bring; 521000 Hours
m
Thank you, but I am asking what is the current format of the metric /fact
HorasContratadas
t
HorasContratadas is total seconds / 3600
m
Thank you, thus I am assuming, is a decimal (float), right?
t
Yes
👀 1
✅ 1
m
So, you want a sexagesimal format
HH:MM:SS
or something like
HH h, MM m SS s
t
It's an expensive metric to see how many hours were released. may have released 2, 3 hours. launches are in seconds, which is why the metric is total seconds/ 3600 for the number of hours. There is a metric formatting, so much so that I am using it as mentioned above, but it counts the days every 24 hours. I wanted to tell you how to let the total number of hours appear, without counting the days.
m
Can you try with this format?
Copy code
{{{||00}}}h 
{{{0.0166666|60|00}}}m;
you must have something like
24h 30m
for 24.5
✅ 1
It is working as expected?