Convert HH:MM AM to HH:00 AM

[SDBoca]

Is there a way to convert HH:MM format to HH:00? for example: 7:08 AM to 7:00 AM?

Thanks,


Sharon

 

[steveandpeggyb]

Try this...


=INT(A1*24)*(1/24)

A1 would be your time and the cell with the formula would be formatted as "
time"

Is there a way to convert HH:MM format to HH:00? for example: 7:08 AM to 7:00 AM?

Thanks,


Sharon