topic round down time to hours in QlikView https://community.qlik.com/t5/QlikView/round-down-time-to-hours/m-p/723280#M674470 <HTML><HEAD></HEAD><BODY><P>Hi, how can I round down time 'hh:mm' to hours? eg. 07:55 will round down to '07:00'</P><P>Thanks.</P></BODY></HTML> Wed, 06 Aug 2014 09:40:45 GMT 2014-08-06T09:40:45Z round down time to hours https://community.qlik.com/t5/QlikView/round-down-time-to-hours/m-p/723280#M674470 <HTML><HEAD></HEAD><BODY><P>Hi, how can I round down time 'hh:mm' to hours? eg. 07:55 will round down to '07:00'</P><P>Thanks.</P></BODY></HTML> Wed, 06 Aug 2014 09:40:45 GMT https://community.qlik.com/t5/QlikView/round-down-time-to-hours/m-p/723280#M674470 2014-08-06T09:40:45Z Re: round down time to hours https://community.qlik.com/t5/QlikView/round-down-time-to-hours/m-p/723281#M674471 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I don't know, if there's a simplier solution, but "maketime(hour(&lt;TimeField&gt;))" should do the trick. If you only set the format, the value stays at 07:55, it's only displayed as 07:00.</P><P></P><P>Kind regards</P><P>Peter</P></BODY></HTML> Wed, 06 Aug 2014 09:51:27 GMT https://community.qlik.com/t5/QlikView/round-down-time-to-hours/m-p/723281#M674471 peterwh 2014-08-06T09:51:27Z Re: round down time to hours https://community.qlik.com/t5/QlikView/round-down-time-to-hours/m-p/723282#M674472 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try below</P><P></P><P>=hour(ceil(time#('07:55','hh:mm'),1/24))</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 06 Aug 2014 09:52:01 GMT https://community.qlik.com/t5/QlikView/round-down-time-to-hours/m-p/723282#M674472 ashfaq_haseeb 2014-08-06T09:52:01Z