Is there a way to generate report on total on / off time as well as use during day/night, etc? Or some other way to get a sense of which lights are on most often?

Yes, you could write a program (per switch) that looks for control on events and increments a variable every time. Then at midnight have another program email you the variable value, and reset it to zero.

Maybe look at the logging as I believe it records off / on and time of event.

Well, I have 85 switches so that's a lot of programs to write. Also, this has the same issue with lights on multiple scenes as below.

The log file is a sort of solution but loading this in excel and then massaging the data so that I can compute on/off combos is time consuming, and the results have a lot of incorrect info because the log records switch actions, and lights on multiple scenes may be turned on by one switch and then turned off by another. So the script parsing the data would need to know the lights which respond to "all off" for instance.

The log as I recall (but no sure)is recorded by device and not scene so on or off for a scene translates to devices going on off. I’d likely write a program to parse rather than do it in excel.

As to writing programs, it would be a task but if you triggered on device change that still happens if a scene caused the change.

Edited 1 hour ago1 hr by hart2hart

If you'd be using this on an ongoing basis, then developing a log parsing program would be your best bet. Yes, you'd have to have a scene to device id table to catch the scene equivalent commands.