Split Hours from Time

[santhoshkunder]

I have a column with time stamp field which contains the time. ie. 7:10:00 AM. I would like to split this field into 2 fields, one with just the Hours portion ie 7 and the other with just the Minutes portion. ie 10.There are some instances where time-stamp is as follows 18:10:00 AM. I tried Left ,Right and some other functions with No luck.

Thanks
santhosha

 

[Luke M]

=HOUR(A2)
=MINUTE(A2)

 

[santhoshkunder]

Thank

I have a column with time stamp field which contains the time. ie. 7:10:00 AM. I would like to split this field into 2 fields, one with just the Hours portion ie 7 and the other with just the Minutes portion. ie 10.There are some instances where time-stamp is as follows 18:10:00 AM. I tried Left ,Right and some other functions with No luck.

Thanks
santhosha

=HOUR(A2)
=MINUTE(A2)

Thanks but some of my data looks like this. 1/22/1900 1:29:15 AM. For this i should get 529 hours.Is there any way to achieve this?

 

[Jon von der Heyden]

To display cumulative hours you can format the cell as: [h]

Or use: =--TEXT(A1,"[h]")

Or: =INT(A1*24)

 

[Luke M]

As Jon said, I think you'll want to use square brackets. The minutes would be similar,
=--TEXT(A1,"[m]")

 

[santhoshkunder]

As Jon said, I think you'll want to use square brackets. The minutes would be similar,
=--TEXT(A1,"[m]")

Thank you both