Get hour time range from time value

[sharky12345]

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?

 

[Wookiee]

Try something like this:

Sub GetTheTime()

Dim datD As Date
Dim strT As String

datD = Now
strT = VBA.Format(datD, "HH")

End Sub

 

[offthelip]

assuming the date/time is in C4 :

=HOUR(C4)&"-"& HOUR(C4)+1

 

[sharky12345]

Guys you are amazing - thanks to you both, I have a choice now!