Formula for Time

[Freeman2022]

Greetings,

Can someone please help me with a formula in excel to export only the hour, for example column A says 5:31:02 AM, I would like column B to say 5:00:00 AM? Thanks in advance

 

[Tetra201]

Try

=FLOOR(A1,"1:00:00")

 

[Freeman2022]

FLOOR(A1,"1:00:00")

PERFECT!!!! That works, thank you so much..

 

[Tetra201]

Glad to have helped.