Jul 27 2020 04:08 AM
Help Please- I have a lot of time data to enter in an Excel Spreadsheet. I would like to type 0955 to then appear as 09:55 in my worksheet. I know I can use a Custom format to display the data but I need to type the colon for each entry. Is there an easy way to avoid this??
Jul 27 2020 04:14 AM
Jul 27 2020 04:35 AM
SolutionJul 29 2020 11:53 AM
Hi,
attached Excel macroenabled workbook. Open it and enable macros.
Open that worksheet where you are going to input timevalues.
Macro starts to fill values from activecell and below it when you type digits to it.
hit ALT + F8 and select TimeMachine - macro to run.
Macro asks you how many timevalues you want to type, answer some amount from 1 to 30000
type first four digits and hit enter
formatted value appears to active cell and cell below will be selected
this happens as long as counter reach the amount of numbers you told it to be coming from you
you can always stop adding new numbers just hitting enter when macro asks new timevalue
Macro checks that you have given only numbers, no more than 24 hours, no more than 59 minutes
and exactly four digits.
Try this with attached workbook or any other workbook. You only have to open this macro workbook
to reach macro or you can copy the code to your personal macro workbook if you like. That way
it would be always available when you use Excel.
Jul 31 2020 11:26 PM
Jul 27 2020 04:35 AM
Solution