Calculate Day and time

[rakeshkumar1890]

how can convert 23142 into day and time

[MarcoWedel]

That might depend on the result you would expect.

[pradosh_thakur]

Not sure you can covert this to any time as there is no decimal part of the number present here but you can try timestamp() function .. It will change it to a date with timestamp as 00:00:00.. anyways what is the output you want to see?

[Thiago_Justen_]

As Pradosh's response you can use timestamp function for that. But your output with this integer number will look like this:

[rakeshkumar1890]

I have used online tool to convert this number into HH:MM:SS

then I got 06:25:42

How I can calculate in qlikview

format : DD:HH:MM:SS

[pradosh_thakur]

I would use this

=Interval(23142/86400,'DD:hh:mm:ss')

replace your field with 23142

[sahadevpatil140]

I have used following expression to calculate Days and Time from given DATENUMBER 23142

=Date(23142,'DD-MM-YYYY HH:MM:SS TT')  convert into Date

=day(Date(23142,'DD-MM-YYYY HH:MM:SS TT'))  To find Day

=Time#(date(23142,' HH:MM:SS TT'))  to find Time

Following attachments shows expected result

Regards,

Sahadev Patil

[rakeshkumar1890]

Thanks all of you

I got the database provides to different values in different conditions

@@Pradosh - I have already applied interval function but due to different values in database I can't map.

I got the solution what I want

Thanks.

[Thiago_Justen_]

Sound's good Rakesh. By the way, if your problem is already solved, please, close the thread.

Cheers

[MarcoWedel]

what is your solution?