ExcelBanter - Convert Date/Time to the Hour

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert Date/Time to the Hour (https://www.excelbanter.com/excel-discussion-misc-queries/48271-convert-date-time-hour.html)

eric_rs1

Convert Date/Time to the Hour

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

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.

eric_rs1

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.

All times are GMT +1. The time now is 12:46 PM.