Elapsed time

Printed From: Crystal Reports Book — Forum Name: Technical Questions

I am trying to calculate elapsed time, but need to count only "work" hours. Example, the work week is Monday thru Friday and the workday is 9 am to 5pm. If the start datetime is Friday at 4:15 PM and the end datetime is 11:30 am Tuesday, I'd like the calculated elapsed time to be 11 hrs and 15 minutes. Is there a way to do that? Thanks!