topic Re: Calcualte time in between Out and In in QlikView

Calcualte time in between Out and In

kakani87 — Thu, 07 Dec 2017 10:54:58 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: Calcualte time in between Out and In

Anonymous — Thu, 07 Dec 2017 11:44:41 GMT

Try this;

=interval( TIMEFIELD2 - TIMEFIELD1, 'hh:mm')

Re: Calcualte time in between Out and In

kakani87 — Thu, 07 Dec 2017 12:15:04 GMT

Michael .... this is working for total time spent in a day but i want for in between out and In duration for breaks in a day here this is not working.

Could you kindly have a look into my attachment and help me out of this issue

Re: Calcualte time in between Out and In

sunny_talwar — Thu, 07 Dec 2017 12:30:08 GMT

Which table are you working with and what is that you expect to see (what are you seeing and what do you want to change)?

Re: Calcualte time in between Out and In

Anil_Babu_Samineni — Thu, 07 Dec 2017 12:33:03 GMT

May be this?

Date(Aggr(Timestamp(MinString({<InOut={'0'}>}SignIn))-Timestamp(MaxString({<InOut={'1'}>}SignOut)), tran_date,EmpName),'hh:mm:ss TT')

Re: Calcualte time in between Out and In

kakani87 — Thu, 07 Dec 2017 12:39:01 GMT

Hello Sunny ...

Below the Employee access table there is a table displayed as IN

In that every out and in break time to be displayed for all employees like how much time they are out from seats

Re: Calcualte time in between Out and In

kakani87 — Thu, 07 Dec 2017 13:01:43 GMT

Sunny If we scroll little down we can see for employee IN and OUT Access time entries properly in a day

@Sunny Talwar

Re: Calcualte time in between Out and In

sunny_talwar — Thu, 07 Dec 2017 13:02:59 GMT

So what do you expect to see here? (Which column? What numbers)

Re: Calcualte time in between Out and In

kakani87 — Fri, 08 Dec 2017 05:03:50 GMT

Employee wise Break time for example,

an empployee is out on 11:0000 amand In on 11:30:00 am

Now the break time is 00:30 - mins

That should be displayed in the chart i mentioned last table

mentioned as 'IN' below Employee Access Details table

the other are for test purpose i have entered they are negligible

emp Signin signout Break time

SAI 10:00:00 am 11:00:00 am 00:30:00 TT

SAI 11:30:00 am

@Sunny Talwar.