Simple issue with cell format

[Peshal]

Hi Every one, Though simple , I am stuck in this trifling issue for few hours now. Frankly speaking I am novice to EXCEL. I want to put my data entries in formatted cells look like 00:00 such that I do not need to type " : " every time I make an data entry. I tried it using custom format h:mm but still there I need to type " : " for each entry.
Is there any help regarding the issue?
It would be greatly appreciated.

 

[Deepak]

Hi,

I think in this case you need to enter hour & minute in two different cells & later convert it by TIME function.

Like As!!

A1= Hour
B1= Minute
C1= TIME(A1,A2,0)


or just want hour then

A1= Hour
B1= TIME(A1,0,0)

 

[Deepak]

...... TIME function.

One more thing to add, if you are using this for data entry time stamp then use NOW function.