One way:

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

Format as hh:mm AM/PM

In article ,
"eric_rs1" wrote:

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.