Microsoft Office Forums - View Single Post - [Solved] time formatting

Thread: [Solved] time formatting

View Single Post

Old

08-25-2016, 10:38 PM

CLEMMON

CLEMMON is offline

CLEMMON uses Windows 10

Windows 10 CLEMMON uses Office 2016

CLEMMON uses Office 2016

Office 2016

Novice

The original poster

Join Date: Aug 2016

Posts: 1

CLEMMON is on a distinguished road

Question

time formatting

How can I format cell A1 so that when I enter the time in military format in A1, it will display as standard time in A1.

Example:I would like to enter 1400 in A1 and have the same cell display 2:00PM

Reply With Quote