Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time entries
I'd like to enter 3 or digits and have them show in a cell as "time".
Ex 1234 = 12:34; 635 = 6:35. Can you assist. Seems I can do nearly every other type of "conversion entry" but the one I now need. Thanks,very |
#2
|
|||
|
|||
One way, using a formula to convert after-the-fact:
=TIME(INT(A1/100),MOD(A1,100),0) Otherwise you would need a worksheet_change event macro that grabs the data right after you enter it and converts it using essentially the same "formula" as above, but written in VBA instead (where the syntax is a bit different). On Sat, 5 Mar 2005 17:19:02 -0800, "Beege" wrote: I'd like to enter 3 or digits and have them show in a cell as "time". Ex 1234 = 12:34; 635 = 6:35. Can you assist. Seems I can do nearly every other type of "conversion entry" but the one I now need. Thanks,very |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing Time | Excel Discussion (Misc queries) | |||
mulitiplying time | Excel Worksheet Functions | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |