Thanks. Works great!
"JE McGimpsey" wrote:
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.
|