Hours

[#1]

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

[sunny_talwar]

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?

[sunny_talwar]

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