Floor Time average calculation

Hi Experts..

Looking for your help on creating a Macro for me help in calculating the average floor timing of teh each employee.

I've attached raw datafile and result data file.

Raw datafile will have the emplyee in and exit timing of the each day for throught out teh month..

Now i just wanted to find how long employee stays inside the office.

The result file will have the formula's i used to find the timings.

Thsi is occupying my time heavily.

Please help.

Thansk,
Safi.

Can Somebody look in to my thread please ?

Many thanks.
Safi.

Hi Safi,

Find the attached sheet with the formula which will match your requirement

Punnam

Thanks for Looking in to Punnam.

Im not sure where i'll have to put this formula on the other sheet. I tried that and got the results are incorrect

Please advise.81835.xls

Many thanks,
Safi.

Hi Safi,

as it is array function it is necessary to use Ctrl+Shift+Enter after any change n formula
Paste the code and use the above combination keys & then drag it down

Punnam