topic Re: Time between in and out Access in QlikView

Time between in and out Access

kakani87 — Wed, 06 Dec 2017 07:23:47 GMT

Hi Every one ....

I'm having biometric data containing employee sign in and out time but now i want to display the time between out and in break time duration.

could any one help me to find out this.

PFA.

Re: Time between in and out Access

zhadrakas — Wed, 06 Dec 2017 07:44:06 GMT

you can simply use this Expression:

TimeStamp1 - TimeStamp2

or in your case

[OUT]-[IN]

your Need to Change your Expressions for [IN] and [OUT] like this:

TimeStamp(.., 'YOUR FORMAT')

currently you are using TimeStamp#()

this one with # just formats the value to a timestamp but doesnt convert it into a real timestamp.

regards

tim

Re: Time between in and out Access

maxgro — Wed, 06 Dec 2017 07:57:36 GMT

In Employee Access Details chart, I think

Max({<InOut={'1'}>}SignOut) - Max({<InOut={'0'}>}SignIn)

then you can format as Interval in the number tab

Re: Time between in and out Access

jonathandienst — Wed, 06 Dec 2017 08:26:13 GMT

Tim Driller wrote:

currently you are using TimeStamp#()

this one with # just formats the value to a timestamp but doesnt convert it into a real timestamp.

That's not correct. TimeStamp#() converts text to a numerical date/time (timestamp) value. TimeStamp() formats a numerical date/time value as a timestamp (without changing the underlying value).

The same applies to Date#/Date, Time#/Time and Interval#/Interval.

Re: Time between in and out Access

kakani87 — Wed, 06 Dec 2017 09:18:02 GMT

I appreciate for quick response from you people Tim Driller and Massimo Grossi but your suggestions are not useful for my issue.

Can any one go through the attachment and help me out of the issue I'm facing difficulty

Regards,

Kakani.