Date/Time Calculation

V

victoriousone

I am trying to calculate resolution time for tickets in a call center.
have the open time and the close time. I'd like Excel to calculate th
elapsed time to resolve the ticket counting only the business hour
that the Call Center is open (7am-6pm M-F). Can anybody help me
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating time differences excluding weekends, holidays 1
time shift and salary calculation 1
NETWORKDAYS 1
creaet a graph from the hours of a time field 1
Elapse date and time 2
How do I get time elapsed in terms of minute? 9
Elapsed Time returned from query 1
Calculating Difference Between Start Date & Time And End Date & Ti 2

Top