Forum Discussion
Wayne Bateman
Jan 18, 2018Copper Contributor
Time Formatting in Excel
I'm trying to create a simple spreadsheet to log times in Excel.
I select the cells to be formatted and apply a TIME format e.g. 13:30
I would would like to be able to type 1330 and get t...
Willy Lau
Jan 19, 2018Iron Contributor
I am not sure if you want it like this:
change the number format as custom
0#":"##
but this is not a time format to Excel
Willy Lau
Jan 19, 2018Iron Contributor
If you type 130, it shows as 0130. However, if you do
=LEFT(<TheCell>,2)
It come out 13.
You must do it like
=LEFT(TEXT(<TheCell>,"0000"),2)
or
=TEXT(INT(<TheCell>/100),"00")
to make it come out with 01.