That is correct for the most part. It doesn't need to be counted twice but it does need to be designated in 2 different categories.   Each Time Log will have a different "reason" and if the reason is "Travel", the time needs to be counted at full value towards Travel Time and half value towards Billable Time.

So, let's say a tech enters the following logs:

Key    Reason     Time
1      Travel     0h 30m
2      Service    4h 0m
3      Lunch      1h 0m
4      Travel     1h 0m
5      Contract   3h 30m

The tech would be credited for 1h30m of Travel Time, 3h30m of Contract Time, 1h for Lunch, and 4h45m of Billable(Service) Time.

I found out that the Stored Procedures are pretty well locked down but I can add views within the database if that will help.

I think I'll need to go with bringing the travel logs in as 2 instances because I'll need them in the charts and cross-tabs. Would I just add another instance of the log entry in the details and conditionally suppress them or would I have to use groups?

Thanks. You have been a big help.