minus using pivot table

  • Thread starter Thread starter ronsrst
  • Start date Start date
R

ronsrst

Hi!,

Can someone help me with minusing data using pivot table or any othe
way, for example:

Emp id Time
111 16:00
111 15:42
111 14:22
111 12:00
222 15:30
222 12:10
222 10:00

Data I have is emoloyee ID and various time that they performe
something in system. In the result I want to get Employee ID and tota
time they were in the system.

This means final result should be
Emp id Time
111 4:00
222 5:30

It just should substract the lowest time from the highest time.

Thanks in advance..
Ro
 
Hi
if you have a list of your employee ID in column A of a separate sheet
try the following matrix formula in column B (e.g. in cell B1;
assumption: your time data is on the sheet 'data'):
=MAX(IF('data'!$A$1:$A$100=A1,'data'!$B$1:$B$100))-MIN(IF('data'!$A$1:$
A$100=A1,'data'!$B$1:$B$100))

Note: enter this as array formula with CTRL+SHIFT+ENTER
 
Back
Top