szakharov7723
Board Regular
- Joined
- Jun 22, 2018
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
So I am working on user interface on one worksheet and not sure how to make time fields more user friendly.
Right now it is just validation list in increment of 5 for minutes and separate field for hours, while I want a user to be able to select any time. E.g 22:47 or 3:21
And I am thinking about something like alarm clock in phone, where all you need is to scroll time with your finger to set hours and minutes.
Is it possible to do it in Excel as well ? (except you scroll with the mouse, not finger)
I find it important to mention, that eventually these times fields will also be used in calculations, so they need to be time format or automatically convertible to it.
Right now it is just validation list in increment of 5 for minutes and separate field for hours, while I want a user to be able to select any time. E.g 22:47 or 3:21
And I am thinking about something like alarm clock in phone, where all you need is to scroll time with your finger to set hours and minutes.
Is it possible to do it in Excel as well ? (except you scroll with the mouse, not finger)
I find it important to mention, that eventually these times fields will also be used in calculations, so they need to be time format or automatically convertible to it.