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


--
Regards,

Peo Sjoblom



"maryj" wrote in message
...
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!
--
maryj