Excel 2010 Time withour year

Closed
crazycdn Posts 1 Registration date Tuesday November 26, 2013 Status Member Last seen November 26, 2013 - Nov 26, 2013 at 10:16 AM
JanardhanTS Posts 10 Registration date Wednesday October 23, 2013 Status Member Last seen March 25, 2014 - Feb 12, 2014 at 05:52 AM
I would like to enter the time in excel by just entering time, Excel however takes the numbers put in as date ...

I have to make a schedule that starts at 00:01 (midnight) through the day until 23:30
So if I wanted to have the time 00:01 I just want to enter the numbers such as 0001 but when I do that Excel sees it as 01/01/1900 12:00:00 AM. Not exactly what I am looking for, I searched everywhere but I can't find how I can enter numbers only for time.

I hope there is someone who can help me.

TIA
Related:

1 response

JanardhanTS Posts 10 Registration date Wednesday October 23, 2013 Status Member Last seen March 25, 2014 1
Feb 12, 2014 at 05:52 AM
Hi,

Chose all those data, Now go to 'Number format' in Number tab of Home.
Go to more 'Number format'
choose 'Custom' then search for 'mm:ss'
click on OK

try now.
0