I assume this is all occuring in a single cell (let's say A2)?
How does Excel know that the user is entering seconds, minutes, hrs, etc?
So if the user enters 23, is that minutes or hours? is there a second cell which has the units in it?