Formatting Average Time

[Guest]

Given a time in and a time out, I can calculate time-spent-waiting. Then, I calculate the average time-spent-waiting by running the Average function across all the previously calculated time-spent-waiting cells. The problem comes with the way the results are displayed. I want to display the results in an h:mm format, but I can only get it to show military time or the decimal equivalent. For example, if the average time-spent-waiting is an hour and a half, I want to see 1:30, but I get 15:50 or 4.6667, depending on how I format it. I'm sure the answer lies in a custom format, but I can't get it to work and I've tried a hundred ways

thanks
Monica

 

[Frank Kabel]

Hi Monica
are you sure your values entered are not larger (maybe also contain a
date). This looks like your average is to high.
Please post some example data and the excat formula you're using

--
Regards
Frank Kabel
Frankfurt, Germany

Given a time in and a time out, I can calculate time-spent-waiting.

Then, I calculate the average time-spent-waiting by running the Average
function across all the previously calculated time-spent-waiting cells.
The problem comes with the way the results are displayed. I want to
display the results in an h:mm format, but I can only get it to show
military time or the decimal equivalent. For example, if the average
time-spent-waiting is an hour and a half, I want to see 1:30, but I get
15:50 or 4.6667, depending on how I format it. I'm sure the answer
lies in a custom format, but I can't get it to work and I've tried a
hundred ways!