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 27 weeks ago
6 years 13 weeks ago
6 years 25 weeks ago
6 years 28 weeks ago
6 years 29 weeks ago
6 years 34 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago