Forum Discussion
WABlok
Jan 15, 2023Copper Contributor
Simple time input
Hello everyone, I'm looking for an easier way to enter times in excel. for example, if I enter 1000 it should be processed automatically to 10:00. So I want to skip the step that I have to enter t...
- Jan 15, 2023
See the attached version. It is now a macro-enabled workbook; you'll have to allow macros when you open it.
If you want to inspect the code, right-click the sheet tab and select 'Code weergeven' from the context menu.
WABlok
Jan 15, 2023Copper Contributor
Send you a PM and file
HansVogelaar
Jan 15, 2023MVP
See the attached version. It is now a macro-enabled workbook; you'll have to allow macros when you open it.
If you want to inspect the code, right-click the sheet tab and select 'Code weergeven' from the context menu.
- WABlokJan 16, 2023Copper ContributorThank you Hans for the effort and time you put in it.