topic Hour format in QlikView https://community.qlik.com/t5/QlikView/Hour-format/m-p/550744#M1133356 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I got a simple problem, i want to know a way to be able to represent hours without needing to do days.</P><P></P><P>For example,</P><P>im using</P><P>Date(0.5046840439363,'hh:mm') and it returns 12:06. as 12 hours and 6 minutes.</P><P>The problem is when i do Date(1.5230717969886,'hh:mm'), it kinda only takes the decimal parte and returns 12:33, i was looking somehitng more like 36:33 hours, insted of spliting it with days.</P><P></P><P>Any ideas?,</P><P></P><P>thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 30 Oct 2013 18:56:23 GMT 2013-10-30T18:56:23Z Hour format https://community.qlik.com/t5/QlikView/Hour-format/m-p/550744#M1133356 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I got a simple problem, i want to know a way to be able to represent hours without needing to do days.</P><P></P><P>For example,</P><P>im using</P><P>Date(0.5046840439363,'hh:mm') and it returns 12:06. as 12 hours and 6 minutes.</P><P>The problem is when i do Date(1.5230717969886,'hh:mm'), it kinda only takes the decimal parte and returns 12:33, i was looking somehitng more like 36:33 hours, insted of spliting it with days.</P><P></P><P>Any ideas?,</P><P></P><P>thanks <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 30 Oct 2013 18:56:23 GMT https://community.qlik.com/t5/QlikView/Hour-format/m-p/550744#M1133356 2013-10-30T18:56:23Z Re: Hour format https://community.qlik.com/t5/QlikView/Hour-format/m-p/550745#M1133357 <HTML><HEAD></HEAD><BODY><P>Time(Frac(youdatefield)) // returns only the hours between 24 period</P><P>or</P><P>Interval(yourdatefield) // returns the interval: 33:06 for example</P></BODY></HTML> Wed, 30 Oct 2013 18:57:01 GMT https://community.qlik.com/t5/QlikView/Hour-format/m-p/550745#M1133357 Clever_Anjos 2013-10-30T18:57:01Z