Production per hour

thordds · Post by **thordds** » Wed Aug 29, 2007 6:21 am

How do i have open dental calculate my production per hour? also can it calculate how many days and/or hours we've been open per month?

Post by **jordansparks** » Wed Aug 29, 2007 4:52 pm

Well, I suppose the information is in the database, but you'd need to have a fancy SQL statement to extract it. The time open would be a query on the schedule table for a specific provider. The production can be the sum of completed procedure fees. I don't personally have time to work on that query.