Excel time extract

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

use a formula like


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


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

d "days" hh:mm

cheers, teylyn
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.