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
6 years 12 weeks ago
6 years 50 weeks ago
7 years 10 weeks ago
7 years 13 weeks ago
7 years 14 weeks ago
7 years 19 weeks ago
7 years 28 weeks ago
7 years 28 weeks ago
7 years 28 weeks ago
7 years 28 weeks ago