Depending what you actually want returned, a string or a number.
Assuming the value is a double formatted as a time:
Public Function GetHourOnly(argRange As Range) As Integer
GetHourOnly = Int(argRange.Value * 24)
End Function
Or
Public Function GetHourOnly(argRange As Range) As String
GetHourOnly = Left(argRange.Text, 2)
End Function
NickHK
"roshinpp_77"
wrote in message
...
HI friends,
Could anyone tell me how to extract first two digits of a "Time
value"
For example in cell B10 the content is 12:00 ie..(Time)
I am not able to extract "12" ie the first two digits of that time.
I am getting 0.5013 when taken as text.
Regards,
TIA
Roshin
--
roshinpp_77
------------------------------------------------------------------------
roshinpp_77's Profile:
http://www.excelforum.com/member.php...o&userid=34924
View this thread: http://www.excelforum.com/showthread...hreadid=569321