T
td
Is there a way to format cell for time so that I can enter
a number (like 700 for 7:00 am)?
Thanks
TD
a number (like 700 for 7:00 am)?
Thanks
TD
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
F
Frank Kabel
M
Myrna Larson
Formatting the contents of a cell is totally separate from the part of Excel
that looks at what you type and interprets it as text, a number, a date, a
time, etc.
It doesn't matter how you've formatted the cell. Formatting as time doesn't
preclude you from entering something else, like text or just a number, etc.
Therefore, for Excel to correctly interpret what you type, you have enter
times in one of the formats that Excel will interpret as a time.
Typing 700 means, to Excel, the number seven hundred. It isn't a time. To be
able to type a time without a colon and have it entered in the cell as a time
requires VBA code to, e.g. take the number 700 that you typed and translate it
to 7/24 (7 24ths of a day), which is the number Excel uses to represent the
time 7 AM.
that looks at what you type and interprets it as text, a number, a date, a
time, etc.
It doesn't matter how you've formatted the cell. Formatting as time doesn't
preclude you from entering something else, like text or just a number, etc.
Therefore, for Excel to correctly interpret what you type, you have enter
times in one of the formats that Excel will interpret as a time.
Typing 700 means, to Excel, the number seven hundred. It isn't a time. To be
able to type a time without a colon and have it entered in the cell as a time
requires VBA code to, e.g. take the number 700 that you typed and translate it
to 7/24 (7 24ths of a day), which is the number Excel uses to represent the
time 7 AM.