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: 
kakani87
Specialist
Specialist

Calcualte time in between Out and In

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.

8 Replies
Anonymous
Not applicable

Try this;


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

kakani87
Specialist
Specialist
Author

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

sunny_talwar

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)?

Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kakani87
Specialist
Specialist
Author

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

kakani87
Specialist
Specialist
Author

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

@Sunny Talwar

sunny_talwar

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

kakani87
Specialist
Specialist
Author

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.