Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to create a master time calendar with numeric values (So I can use continous axis)
But when I use the floor function, some minutes are grouped as one.
i.e. the minute 00:08 disapears and the minute 00:07 has two values.
But if I load the minutes as text, all minutes are displayed (but as text, and not as numbers)
What am I doing wrong?
I have uploaded an example of this!
This is the code i'm using to load the minutes:
LOAD Time(Floor(Frac(A),1/1440),'hh:mm') as [HH:mm],
Text(B) as [HH:mm_txt]
FROM
[Test_HoraMinuto.xlsx]
(ooxml, no labels, table is Hoja1);
I'm using floor because in the original data i also have seconds! (and I dont need seconds)
Hi,
Try:
Time#(A,'hh:mm') as [HH:mm]
Regards
Neetha
Try this:
If(RowNo() = 1, Time(Floor(Frac(A),1/1439),'hh:mm:ss'), Time(Floor(Frac(A),1/1439) + 0.00069444444444444,'hh:mm:ss')) as [HH:mm]