View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nena Nena is offline
external usenet poster
 
Posts: 1
Default Coditional Formatting?

I need help. I'm not sure how to ask this question. I'm trying to average
the number of entries during a specific time frame with a formula (or
anything else). This is what my data looks like:
UserName
4:57:48 PM Login
4:59:57 PM Add Record
5:02:21 PM Add Record
6:59:17 PM Add Record
8:34:56 PM Logout
This user created 3 entries in 3hrs and 37mins. Average of 1 every
1:12mins). Can anyone help?

--
Nena