Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lukaspuschner
Partner
Partner

time in man-day

Hello, i have the following problem.

I have a field with time values and i have to get the man-days out of it. For example:

08:00:00 should be 1

01:00:00 should be 0,125

can you help me how to get this?

1 Solution

Accepted Solutions
lukaspuschner
Partner
Partner
Author

sorry, that wasn 't the problem, but the question wasn t exact enough.

I solved it by my self. Thank you

View solution in original post

2 Replies
robert_mika

If that only first two numbers will be taken into account:

=LEFT('01:00:00',2)/8

lukaspuschner
Partner
Partner
Author

sorry, that wasn 't the problem, but the question wasn t exact enough.

I solved it by my self. Thank you

View solution in original post