Can it be possible to change excel formulas in QlikView?

[ASEDavidSu]

I want to change some data from excel by using QlikView. 
I want to convert the left side data(c) into the right side(d) by only using qlikview. There’s the coding form from excel on the top of the pic for reference. Tks for help!!!!!!!!

[MarcoWedel]

maybe

Timestamp(Floor(C,'03:00'))

or

Timestamp(Floor(C,1/8))

?

[ASEDavidSu]

Sorry, it doesn’t work 😢btw tks for help. Appreciate!!

[MarcoWedel · Accepted solution]

seems to work for me though

table1:
Load *,
     Timestamp(Floor(C,'03:00'),'YYYY/MM/DD hh:mm:ss') as D,
     Timestamp(Floor(C,1/8),'YYYY/MM/DD hh:mm:ss') as D2;
Load Timestamp#(Timestamp(Now()-Rand()*10,'YYYY/MM/DD hh:mm:ss'),'YYYY/MM/DD hh:mm:ss') as C
AutoGenerate 100;

Can you share some screens of what you did and how your result looks like?

[ASEDavidSu]

 

 

 

Here’s the result🥲🥲

[ASEDavidSu]

It works! Appreciate your help!!!

[MarcoWedel]

glad it helped.