Entering time.

  • Thread starter Thread starter J. Madden
  • Start date Start date
J

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
 
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.
 
Hi
for a formula approach you may use the following formla in an adjacent
cell
=TIME(INT(A1),MOD(A1,1)*100,0)
 
Back
Top