topic Converting Times in QlikView

Converting Times

Anonymous — Wed, 27 Oct 2010 11:00:25 GMT

Hello,

I have stored times in my database with the minutes in 100 base, so that it works well with the maths counts, but I'd like to show the results in the time format.

Example

4,75+4,75=9.5 hours ---> Graphically 9:30 hours.

Can anyone help me?

Thanks.

Converting Times

Wed, 27 Oct 2010 11:06:58 GMT

HH:MM

Converting Times

Anonymous — Wed, 27 Oct 2010 11:19:21 GMT

Sorry, Can you explain better to me? (I'm a rookie).

In the table I have the Sum expression for the hours in format like 9,5 and I'd like to display the results in 9:30.

Which choise I have to make in the Numer Tag?

Thank you.

Converting Times

Wed, 27 Oct 2010 11:20:56 GMT

Hi,

First you will need to convert your number into a format that can be converted into time (like 9:30 would be = 0.395833) then do a code like

=Time(.395833,'HH:mm')

make sure the m is small letter or else it would be in Month Format.

Regards,

Converting Times

Wed, 27 Oct 2010 11:35:59 GMT

I found a better way of computing it..

=Time((your number)/24,'hh:mm')

lets say your number = 9.5 then it will result to 9:30, if your number is 10 then it will result to 10:00

Regards,

Converting Times

Anonymous — Wed, 27 Oct 2010 12:54:51 GMT

Sorry, but it doesn't work properly:

Time (9.5/24,'hh:mm')=9:30

but

Time(9.25/24'hh:mm') doesn't show 9:15 but 9:12 (!)

Thanks.

Converting Times

Anonymous — Wed, 27 Oct 2010 13:11:17 GMT

Solved!

I put in the expression 9.25/24 and in the tag Number the format Hour hh:mm

Thank you very much for the suggestions.