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!
Bookmarks