Would anyone have a suggestion on how to get a Business Hour Calculation for dates and times specified in the format below in Excel? I have tried multiple formula combinations with no success. In this case business hours are considered 7am - 6pm cst M - F. The data is imported from another tool in this format and seems to be difficult to work with. Unfortunately I am not a savy VBA user
9/19/2006 16:42
9/20/2006 16:42
Any assistance or ideas are greatly appreciated.
Thanks,
Michael
9/19/2006 16:42
9/20/2006 16:42
Any assistance or ideas are greatly appreciated.
Thanks,
Michael