Suggestions for organizing spreadsheet needed

New Contributor

I have created a spreadsheet to track the amount of time our technicians are at certain properties.  This spreadsheet is currently able to give me an overall average of time spent by all technicians at a property during the month, but I need a way to show the averages of each technician for each property.  Pivot tables have been suggested, but I can't seem to get it to work with the current layout.


Any suggestions?

3 Replies

@Tom_Clean_Sweep_4187 , yes, that's hard to work with the data structured such way. Formula could be (in C43) 


drag it down and copy column on other properties.

@Sergei Baklan Thank you very much for your assistance.  The organization of my spreadsheet made getting this information tough and I didn't even know where to start.  Your formula got the result I needed!

@Tom_Clean_Sweep_4187 , first thing is to avoid cells merging which gives a lot of side effects. Alternative is to format cells with Center Across Selection


Another point it's always better to separate row input data and aggregations. As variant that could be 4 columns with date, hours, name and property (two latest could be picked-up from drop-down lists), another table with properties and goals, after that combine results in separate PivotTables or like. But concrete organization depends on your business rules as well, main idea is separation.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies