how do i add different cell ranges using a formula

[Norman K via OfficeKB.com]

Hi

i have a situation as follows

Time sheet
col1 col2 col 3 col4
date time name total

06/05/2005 03:32:02 kevin
06/05/2005 03:58:11 kevin
06/05/2005 00:03:15 kevin 7:33:28
07/05/2005 09:03:24 kevin
07/05/2005 00:06:49 kevin 9:10:13
08/05/2005 02:37:02 mark
08/05/2005 06:32:36 mark
08/05/2005 00:03:28 mark 9:13:06

is it possible to create a formula to add the time in col 2, on change of
date "and or" name??

Thanking you in advance

Regards

Norman

 

[Bob Phillips]

Norman,

Look at Data>Subtotals.

 

[Norman K via OfficeKB.com]

Thanks Bob, it works, much appreciated

Regards

Norman