Coditional Formatting?

[Nena]

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?

 

[Pranav Vaidya]

Hi Nena,

here's how you will do this.

Say your belo data is in Column B and column C resp.

type the below formula where you want the average-

=(B6-B2)/COUNTIF(C2:C6,"Add Record")

Here B6 is LogOut cell and B2 is LogIn cell.

Also make sure you do not have any other entries in between log in and log
out otherwise your aveage will be wrong.
Also the cell in which you will type the formula should be formatted as
HH:MM:SS to see the result.
Hope this helps!!