Master Time Calendar

[cristian_av]

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);

[cristian_av]

I'm using floor because in the original data i also have seconds! (and I dont need seconds)

[Anonymous]

Hi,

Try:

Time#(A,'hh:mm') as [HH:mm]

Regards

Neetha

[sunny_talwar]

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]