Inserting Blank Rows At Change

[robcarr]

I have this peice of data that i need to import daily to Excel,how can I summarise each name below there last entry, the times are log in and log out times so the number of entries cahnges all the time, and I need to know total time logged in summarised below each change of name, Can anyone help with this as I am finding this really confsuing and difficult to do.

thanks.

name1 08:05 12:02
name1 12:31 15:55
name2 08:02 13:08
name3 18:05 18:07
name3 18:07 23:07
name4 17:59 21:59
name5 12:00 14:54
name5 14:55 16:21
name5 16:52 20:00
name6 10:03 15:03
name7 11:59 12:00
name7 12:00 16:40
name7 18:50 20:00
name8 12:03 20:00
name9 11:58 12:00
name9 12:00 16:02
name9 16:32 20:00
name10 11:59 12:00
name10 12:00 14:19
name10 14:19 16:02
name10 16:33 20:00

 

[acron]

If your existing data is in Columns A, B and C, enter a formula in column D to compute the time (C - B).

You can the use the Subtotal feature to calculate the tiome for each name. Go to Data, Subtotals, and use For each change in Name, Use function SUM, add Subtotal to TIME (or whatever heading you gave to column D).

A.C.