calculation to get the number of hours worked

[rishi.luximon]

Hi Guys,

Actually i'm collecting data from a RFID reader and data shows the time in and out of employees. Normally if an employee works on a shift system the time in will be calculated time/date=X and time out will be time/date=Y that is two different dates. for example shift workers will have time in today at 6:00pm and time out tomorrow at 2:00am. can somebody tell me the calculation to get the number of hours worked for this employee or have a better idea how to proceed.

Thanks....... :D

[comment]

the time in will be calculated time/date=X

Not sure what "time/date=X" means. If you only have time data, you can use =

EndTime - StartTime + ( EndTime < StartTime ) * 86400 

to calculate the duration. Note that this assumes duration does not exceed 24 hours.

[rishi.luximon]

Hi,

What I mean by time/date=X is:

Date= 01/01/2011(dd/mm/yyyy)

StartTime= 18:00:00

Date= 02/01/2011 (Next day)

EndTime= 03:00:00

As you see the date is different but it should count as 1 day worked and I should be able to get the answer= 9:00:00hrs

Please help!!!!!!!!

Sorry for duplicating the post.

Thanks..

[Raybaudi]

... and the comment's calc ( result type: time ) is correct:

3 - 18 + 24 = 9

[comment]

If you also have a StartDate and EndDate, make the calculation =

Timestamp ( EndDate ; EndTime ) - Timestamp ( StartDate ; StartTime ) 

As Daniele noted, the result type should be Time.

We are assuming here that all four fields are in the same record. If that's not the case we need more information about how your data is organized.

[rishi.luximon]

Many thanks guys,

I will try it.

Cheersssss