Cell Formats

  • Thread starter Thread starter Gav
  • Start date Start date
G

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
 
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
 
Then,you do it by VBA

Paul said:
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
Click to expand...
 
Back
Top