Entering time.

[J. Madden]

Is there a way I can enter time using a decimal instead of the colon and
have it still figure using the 60 minute hour?

For example for 9:45 I want to enter it as 9.45 but have it treated as 9:45.
This is only for speed in data entry. I can use a ten key quicker then I
can hit the colon. I use military time if it helps.

Thanks,
Joe

 

[JE McGimpsey]

Check out

http://cpearson.com/excel/DateTimeEntry.htm

 

[Frank Kabel]

Hi
see:
ttp://cpearson.com/excel/DateTimeEntry.htm

 

[J. Madden]

Yeah I have seen that, but I don't have a clue how to implement it. I was
hoping someone would have a forumula that would do what I want.

 

[Frank Kabel]

Hi
for a formula approach you may use the following formla in an adjacent
cell
=TIME(INT(A1),MOD(A1,1)*100,0)

 

[J. Madden]

THANK YOU!!! Exactly what I wanted.

You ROCK!!!!