Time between in and out Access

[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.

[zhadrakas]

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

[maxgro]

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

[jonathandienst]

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.

[kakani87]

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.