Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lukaspuschner
Partner - Creator
Partner - Creator

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 - Creator
Partner - Creator
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
Master III
Master III

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

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

lukaspuschner
Partner - Creator
Partner - Creator
Author

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

I solved it by my self. Thank you