Calcualte time in between Out and In

[kakani87]

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.

[Anonymous]

Try this;

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

[kakani87]

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

[kakani87]

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]

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]

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.