Convert Date/Time to the Hour

[eric_rs1]

Is there a formula to convert this 1/3/2005 11:39:02 AM to this 11:39 AM. I
have formatted the cells but that merely changes what the user will see and
not the true value of the cells.

 

[JE McGimpsey]

One way:

=ROUND(MOD(A1,1)*1440,0)/1440

Format as hh:mm AM/PM

 

[eric_rs1]

Thanks. Works great!

One way:

=ROUND(MOD(A1,1)*1440,0)/1440

Format as hh:mm AM/PM