Hi Frank,
Thanks for taking the time to address this issue.
I have a couple of questions though. How come, if I actually select the
cells, and then select format as time (12:34:57) it still retains this 'text'
formatting? Is it something associated with the spreadsheet itself? Also when
you say 'Helper column', I'm sorry I'm afraid I don't understand, should I be
replacing the A1 value with the range of cells I want formatted or something?
Sorry to be such an idiot here, it just seems like it should be a little
easier than it is...kinda like life that way huh?

Thanks,

"Intotao" wrote:

Hi Everyone,
I have a question about sorting times. I have a spreadsheet with 5 columns.
First column is the name of the staff, 2nd - 5th column are the times
associated with the staff member.
These are hours associated, for example 1 hour and 26 minutes (as opposed to
1:26 pm). I have tried formatting as 30:34:12, as well as hh:mm:ss.
Regardless of how I format them it doesn't sort correctly.
The top 6 values for example should be
1:26:22
1:04:33
1:02:42
:52:45
:51:00
:48:00


Yet everytime I try to sort it returns the values as such:
1:02:42
1:04:33
1:26:42
:17:24
:24:32
:29:22

HELP! It's driving me nuts! What am I doing wrong?

Many thanks in advance,

Intotao