Cell Formats

[Gav]

Hi can anyone help?

Within an Excel sheet I am recording time and each cell is
formatted as hh:mm. I want to know if it is possible to
be able to enter data as lets say 0800 and Excel
automatically inserts a : to separate hh:mm.

Thanks

 

[curllion]

custormer define ##":"##

 

[Paul]

But this doesn't actually make a time value! Type 3456 and you just get
34:56, which isn't any time I recognise. Even if you can recognise, for
example, 12:34 it will not calculate correctly.

Entering times without a colon takes more than formatting to achieve. You
need a macro. In my opinion, it isn't worth it, but that's your choice. For
details if you do want to do it, look here:
http://www.cpearson.com/excel/DateTimeEntry.htm

 

[J.E. McGimpsey]

Check out

http://cpearson.com/excel/DateTimeEntry.htm

 

[curllion]

Then,you do it by VBA

But this doesn't actually make a time value! Type 3456 and you just get
34:56, which isn't any time I recognise. Even if you can recognise, for
example, 12:34 it will not calculate correctly.

Entering times without a colon takes more than formatting to achieve. You
need a macro. In my opinion, it isn't worth it, but that's your choice. For
details if you do want to do it, look here:
http://www.cpearson.com/excel/DateTimeEntry.htm