Export Start of Hour in excel

[Freeman2022]

Greetings,

Does anyone know of a formula that would export only the start of the hour, for example the date\time in cell A1 is 4/3/2023 8:41:00 AM, I would like to export only 8:00 AM in column B1?

 

[Fluff]

How about

=hour(a1)

 

[Freeman2022]

How about

=hour(a1)

Thanks for the quick response, however I did try that and it returns 12:00 AM

 

[Fluff]

Format the cell as general.

 

[Fluff]

If you need it to still be a valid time, then use

=TIME(HOUR(A1),0,0)

 

[Freeman2022]

Format the cell as general.

Yep tried that also, it returns only the number 8 instead of 8:00 AM

 

[Freeman2022]

If you need it to still be a valid time, then use

=TIME(HOUR(A1),0,0)

AWESOME!!! Thanks works...Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.