Need Help figuring time difference
I have a spreadsheet that brings in multiple fields of data. I need to figure out a formula that will allow me to figure the amount of time worked on each customer by each representative. My event field is either Record opened, Record saved, Record closed, or start create record. The only two that matter for figuring time worked are record opened and record closed. Any idea on how I can figure the time worked on each customer and sort it by representative who did the work? I have attached a sample of what my spreadsheet looks like for reference. Thanks!! Any assistance would be appreciated!!
Attachment | Size |
---|---|
test1.xlsx | 11.21 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago