entering time

[Glen in Orlando]

hello all..
wondering if there is any way to do this...

I have a column formatted for time as in this format 12:00
when entering a time it is cumbersome to have to enter the hour, then a
colon, then the minutes.
Is it possilbe to simply enter a 4 digit number such as 1245 and have it
show up as 12:45 ??

thanks so much... I've found this group to be irreplaceable...

glen in orlando

 

[Tod]

Enter your times without colons in column A and put this formula in column B

=(A1-RIGHT(A1,2))/2400+RIGHT(A1,2)/(24*60)
and format column B for "Time" in the form you want it.
Tod

 

[RagDyer]

You can try this:

http://tinyurl.com/r3ngw

 

[Glen in Orlando]

thanks guys!!

glen

You can try this:

http://tinyurl.com/r3ngw