Help to complete a code

[atmakefka]

Sorry,
In fact I need two programs, yours rocks, but I need

One which caculate the connection time for a specified/given/provided user and period

The another which count the number of sessions opened/connexions for a specified/given/provided user and period, ignoring those under 1 minute during

Yours is good but does both at the same time^^
just that

[Bob Phillips]

In fact I need two programs,

...

Yours is good but does both at the same time^^

Surely, if you get both at the same time isn't that better, why would each individually be preferred?

If you must have individulaly, how do you decide which?

Also I think we (you) need a better input method, inputboxes are flaky.

[atmakefka]

Your right, anyway thanks for all

[atmakefka]

Hello
I need one again your talent

I have 2 sheets (always the same...) :


Column B : The date where the user connected/opened his session
Column D : The date where the user disconnected/closed his session
Column C : The hour he opened
Column E : The hour he closed
Column F : the user/login


Column A : user name:login
Column B : A groupe on which user belongs

I must extract the informations of the first picture (ID, date, connection time etc of the user) in a new sheet by giving a specify groupe
For instance, if the groupe I input in the message box is "Profs", the program must find and extract all the users who belong to that groupe and copy/extract informations in a new sheet
any idea ? thanks

[Bob Phillips]

Post a new workbook with Profs in please.

[atmakefka]

http://kof54.free.fr/data.xls

2sheets in the workbook
profs is just an example^^ there are other groups

[atmakefka]

[Bob Phillips]

Patience! You will like it

Don't forget I do this for free in my own time.

[atmakefka]

thanks

[Bob Phillips]

Ok, try this http://flypicture.com/p.cfm?id=49437

BTW, what do you mean by

profs is just an example^^ there are other groups

[atmakefka]

Thanks
I meant the different groups are in the second column of the second picture, the different groups are "profs", "etudiant DEUST 3eme annee", ...
anyway it's good, thanks for all