| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time_report_date-wise_employee-wise
I am having date-wise, employee-wise login logoff data in Col A to C as under
DATE EMP_NO TIME 01/03/2014 1525336 09:04 01/03/2014 1525336 09:04 01/03/2014 1525336 09:27 01/03/2014 1525336 09:41 01/03/2014 1525336 09:58 01/03/2014 1525336 10:06 01/03/2014 1525948 10:14 01/03/2014 1525948 10:14 01/03/2014 1525948 10:22 01/03/2014 1525948 10:47 03/03/2014 1525336 10:13 03/03/2014 1525336 10:53 03/03/2014 1525336 10:59 03/03/2014 1525336 11:04 03/03/2014 1525336 11:19 03/03/2014 1525336 11:36 03/03/2014 1525948 10:16 03/03/2014 1525948 10:17 03/03/2014 1525948 10:17 03/03/2014 1525948 10:18 03/03/2014 1525948 10:18 03/03/2014 1525948 10:37 04/03/2014 1525336 10:09 04/03/2014 1525336 10:13 04/03/2014 1525336 10:23 04/03/2014 1525336 10:43 04/03/2014 1525948 10:12 04/03/2014 1525948 10:13 04/03/2014 1525948 10:14 04/03/2014 1525948 10:14 04/03/2014 1525948 10:20 What I want is date-wise, employee-wise login (starting time) logoff (ending time) report for each of the employees as example given for the above list as under; DATE EMP_NO LOG_IN LOG_OUT 01-03-2014 1525336 09:04 10:06 01-03-2014 1525948 10:14 10:47 03-03-2014 1525336 10:13 11:36 03-03-2014 1525948 10:16 10:37 04-03-2014 1525336 10:09 10:43 04-03-2014 1525948 10:12 10:20 Help please. Regards. -via135 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can recalculation be set to "row wise" or column wise" ? | Excel Discussion (Misc queries) | |||
| row wise query | New Users to Excel | |||
| row wise query | Excel Discussion (Misc queries) | |||
| Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
| Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions | |||
Threaded Mode
