Quick, clean, and to the point

Apply time format

Windows shortcut 
Mac shortcut 

Apply the Time format with the hour and minute, and indicate A.M. or P.M.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables