Hours billed per RO

[beckleyauto]

I asked this on Jan 22nd but didn't get an answer.

I can measure what the labor sales (in dollars) are for various makes but I need to know the hours billed per RO for different makes. Example BMW = 3.2 hrs per invoice. Toyota = 2.1 hrs per invoice. GM = 1.8 hrs per invoice, etc.
Tiered labor rates and canned jobs make simply dividing dollar sales by invoices misleading (Was that a $130 diag hour or a $95 tire rotation hour?) How can your program accommodate this?

[Silky7]

Steve,

Apologies for missing your previous post. As for your question, I don't have any easy way to come up with the data you're after. The only option I can think of would involve some fairly complex SQL queries of the database.

[beckleyauto]

I agree about the SQL query. I used to be able to do much with Excel and smcore32.mdb but the sql db locks me out. Report pro has "build a query" but the files you can address are limited. This info would be very useful. Any work arounds?