calculating time

[Guest]

This is a 2 part question.

I have cells formatted as [hh]:mm:ss. I enter a time of 5 minutes and 10
seconds as 0:05:10. The cell displays the same as I typed it. In the formula
bar it displays as 12:05:10 AM. Am I correct that there is no way to have the
formula bar only display 05:10?

2nd question:
I want to find the average of times and have them display as a decimal.
The times I am averaging are (all min:sec): 5:00, 10:10, 5:10, 5:00, 5:13.
The result I get when formatted as [hh]:mm:ss is 00:06:07. How do I have this
show as a decimal? Do I just multiply by 24 for the result of .10183? That
just doesn't seem quite right.

Thanks for your help!

 

[Peo Sjoblom]

If you change your regional settings in the windows control panel to 24
hours instead of AM/PM it would display as 00:05:10

 

[Guest]

If your regional settings for time are set to am/pm, 12:05:10 AM is the
actual time associated with the 24 hour version of 00:05:10 - if you change
the regional setting for your computer, it will change the way it looks in
the formula bar, but also for anywhere else time is displayed.

If the times to average were in the range B1:B5 the following formaula would
display the seconds in an average time as a decimal number:
=MINUTE(AVERAGE(B1:B5))+SECOND(AVERAGE(B1:B5))/60
Adjust as necessary and format the cell to numeric.