Software

Ask something
Question Locked

Excel question calculating an average turn around time

0 helpful
3 replies

by klamb

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a cvs report that calculates a turn around time from when a report was dictated to when it was transcribed. I drop this report into Excel so that I can then calculate the average TAT of all reports. My trouble comes when the TAT is greater than 24 hours. The data comes in the format d hh:mm:ss (for example 1 02:11:01). I have tried applying a custom format with d:hh:mm:ss and also d.hh.mm.ss. Everything I try completely ignores the day when doing the calculation.

3 replies

by locolobo

this will work;

Right Click on the cell
Choose Format Cells - Number Tab - Custom

Under Custom formats is one labelled

h:mm

Is that what your looking for?

by klamb

I've found what I would call a work around and just add the hours; for example the value for 1 day 2 hours (1 02:00:00). After I apply the custom format d.hh:mm:ss, I click on the cell and backspace over 1 02 and change it to 26 (1 day =24h + 2hours) and it applies the format so that the average calculates. Since the values that are greater than 24 hours import in the general format rather than the right indent number format, at least they are easy to pick from the list.

This discussion is closed to new replies.