how to split time in columns

[SALO2]

I trying to split time that is in one cell into multiple so that I can then you formulas to get the information that I want. (sumif, countif, etc) In the cell I have them for example 9:30:04 AM . I want to split it other cells just to 30 in one cell. I the next cell :04. I tried use the =left command but it gives me weird numbers back. For example =left(J25,2) returned .39. I’m using excel 2000. If any one has some suggestion It will be much appreciated.

[VBA Noob]

SALO2,

Welcome to the forum. Please read the forum rules below and then add the link to the cross post

VBA Noob