Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Below is my data
SYSTEM - 01/04/2015 01:28:51 PM# |
SYSTEM - 01/04/2015 01:49:07 PM# |
SYSTEM - 01/04/2015 02:05:21 PM# |
SYSTEM - 01/04/2015 02:09:13 PM# |
SYSTEM - 01/04/2015 02:09:38 PM# |
SYSTEM - 01/04/2015 02:13:22 PM# |
In the above data , I have to take only the hour and min .
The Time has to converted to 24 Hours Format.
Need input on this
Hahahaha ya I experience the same problem with some other users . But I don't see why it would be a problem with hours 10, 11 or 12?
I see what you mean. Just need to change from where and to how many:
=Time(Time#(Mid('SYSTEM - 01/04/2015 11:28:51 PM#', 21, 11), 'hh:mm:ss TT'), 'hh:mm')
Good eye Kranthikumar
Best,
Sunny