Excel time extract

We are needing to figure out a way to extract out of excel the turn around time of our helpdesk tickets.
HD-Ticket-Times.csv
lesitAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

use a formula like

=C8-B8

then format the result to show the desired unit, for example, if you want the result in hours, use the custom format

[hh]:mm:ss

If you want the result in days and hours, use a custom format like

d "days" hh:mm

cheers, teylyn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.