TIME ISN'T ON MY SIDE: Control Time input in HH:MM:SS

[cmore]

Hi,

Forgive me for this question, but I'm having trouble controlling time inputs. So I use the code below to allow inputs in minutes, but (a) I'm wondering if someone has a better way? (b) having trouble with ignoring the conversion if it's already in HH:MM:SS format? This code doesn't work for (b) at all

Please Login or Register  to view this content.

[:) Sixthsense :)]

Please Login or Register  to view this content.

Source:

http://excel.tips.net/T003292_Checki...ime_Input.html

[cmore]

Very nice, not sure why I couldn't find this, that guru title isn't wasted on you sir! and I'm off to do more battles with time