topic Re: Time stamp to Hours is not extracting properly in QlikView

Time stamp to Hours is not extracting properly

shaan007 — Mon, 20 Apr 2015 01:52:07 GMT

Hi All,

I am trying to extract the 24 hour time from a timestamp Date Time

example ;

,Time(round(frac([TransCont DateTime]),1/24), 'hh') as [TransCount 24 Hours]

but the the table is showing

I noticed its converting 9.30-10.30 as 10 and 10.30-11.30 as 11.

Please anyone got any idea? how can i create a correct table

rwunderlich — Mon, 20 Apr 2015 02:36:19 GMT

That's because you are using round(), and those appear to be correct rounding. If you just want the hour, use:

hour([TransCont DateTime])

-Rob

jagan — Mon, 20 Apr 2015 02:37:44 GMT

Hi Prasanna,

Below script working for me, please check

Hour(TimeStamp#(TimeStam, 'M/D/YYYY hh:mm tt' )) AS Hour

Regards,

Jagan.

shaan007 — Mon, 20 Apr 2015 02:55:24 GMT

Thank you Rob,

It worked.

pratap6699 — Thu, 04 Jun 2015 16:09:09 GMT

Productive and Nonproductive Hrs. for each week
Number of Employees present each day of the month per supervisor
Avg. Time Spent by Employee on Floor
Calculate Team Utilization (use formula -Total time/Number of days per activity )

anybody solve this please