View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Collecting and summing data

I have a spreadsheet I use to log system outages when they occur and I need
to sum them up together.

Example: Data Entered
Server 2 8/1/09 4.5 hours
Server 1 8/2/09 .5 hours
Server 2 8/2/09 .25 hours
Server 1 8/3/09 1.5 hours

What I want is to be able to automatically add the time up by Server so I
get this:
Server 1 Total hours 2.0 hours
Server 2 Total hours 4.75 hours

Can anyone assist please? I am not real strong in excel so any help would be
greatly appreciated.

Thanks!