Extract the hour from a cell showing the date and time

[Paul Sexton]

I have a field that shows Date and time in the same field. That shows like
this

1/3/05 12:06 PM

I need to extract either 13:00 or 13 or 1 PM from this field. Text to
collumns does not work. I need a formula.

Can you help?

Paul

Hi

I don't quite understand why you want 13:00, but as a start, try:
=MOD(A2,1)
This will 'chop off' the date bit, leaving just the time section.

Hope this helps.
Andy.

"Paul Sexton" <PaulSexton@discussions.microsoft.com> wrote in message
news:30A25C32-5AFE-433D-B33F-064484348C1E@microsoft.com...
>I have a field that shows Date and time in the same field. That shows like
> this
>
> 1/3/05 12:06 PM
>
> I need to extract either 13:00 or 13 or 1 PM from this field. Text to
> collumns does not work. I need a formula.
>
> Can you help?
>
> Paul

[Carl Hilton]

Why not try HOUR() or HOUR(TIMEVALUE()).

Carl

"Paul Sexton" <PaulSexton@discussions.microsoft.com> wrote in message
news:30A25C32-5AFE-433D-B33F-064484348C1E@microsoft.com...
>I have a field that shows Date and time in the same field. That shows like
> this
>
> 1/3/05 12:06 PM
>
> I need to extract either 13:00 or 13 or 1 PM from this field. Text to
> collumns does not work. I need a formula.
>
> Can you help?
>
> Paul