Hi - Help! This is probably really simple, but I cannot figure it out. I am
working with a spreadsheet that has three columns that I need to look like
this...

A B - Time C - Total Time
Text 03:05:28 03:05:28
Text 01:10:30 04:15:58

03:05:28 is 03 hours, 05 minutes, and 28 seconds.

How do I format the cells for column B so that I can just type in "030528"
and have it look like column B?

Also, what is the formula for column C to add the time up? Any suggestions?

Thanks!!!
Jessica