sharky12345
Well-known Member
- Joined
- Aug 5, 2010
- Messages
- 3,404
- Office Version
- 2016
- Platform
- Windows
I'm trying to work out how to get the hour time range of a time value - my values are formatted as Custom "dd/mm/yyyy hh:mm".
In my example, the value is 09/12/2022 14:21 so the result I would expect is 14-15, (i.e. between 2pm and 3pm).
I don't mind if this is achieved by a formula or VBA, if someone can start me off please?
In my example, the value is 09/12/2022 14:21 so the result I would expect is 14-15, (i.e. between 2pm and 3pm).
I don't mind if this is achieved by a formula or VBA, if someone can start me off please?