Format a cell as seconds

[Lisa]

Is there a way to format cells to appear as seconds. I
would like to type 7 and have it generate a 0:00:07. I
know that I could use the TIME function for this, but I
would need two cells for that. I want to format the cell
I'm working in.

Thanks!

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/DateTimeEntry.htm

 

[Lisa]

Thank you.

-----Original Message-----
Hi
have a look at
http://www.cpearson.com/excel/DateTimeEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany


.