|
how do i add different cell ranges using a formula
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200509/1 |
Norman,
Look at DataSubtotals. -- HTH Bob Phillips "Norman K via OfficeKB.com" wrote in message ... 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200509/1 |
Thanks Bob, it works, much appreciated
Regards Norman -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200509/1 |
| All times are GMT +1. The time now is 03:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com