minutes and hours

[Kimber]

I have a format in a cell using the minutes and hours option in Excel and it
will not take it. I want to be able to type in 15 and it gives me 15
minutes. What is the solution to my problem. Please help. I am on a time
restraint.

 

[tjtjjtjt]

What fomat are you using?
If it uses hours and minutes, try typing 0:15.

tj

 

[Kimber]

My client would like to avoid typing in the zero before. Is there another
way? They would like to just type in the 15.

 

[tjtjjtjt]

Check out this web site for the answer. It's likely going to take VBA code:
http://www.cpearson.com/excel/DateTimeEntry.htm

tj

 

[Kimber]

Excellent! Thanks this is going to help!

Check out this web site for the answer. It's likely going to take VBA code:
http://www.cpearson.com/excel/DateTimeEntry.htm

tj