Is there a way to format a cell so that if you enter a time, such as
entering :30 into A3, and having Excel automatically changing that
value to decimal, in this case, .50?

So if I enter :30, hit enter, and it changes to .50 in the same cell?

Thanks!


--
bellz
------------------------------------------------------------------------
bellz's Profile: http://www.excelforum.com/member.php...o&userid=30429
View this thread: http://www.excelforum.com/showthread...hreadid=500990