See http://www.cpearson.com/excel/DateTimeEntry.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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