Time conversion in Excel

[Guest]

I need a macro/vbs/directions on:

In a cell, entering 2345 and having it displayed as :23.45, or entering
12345 and having it displayed as 1:23.45 ... As a swimming coach I would find
this a great help.

Thanks for the insight...

JCJ

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need a macro/vbs/directions on:
|
| In a cell, entering 2345 and having it displayed as :23.45, or entering
| 12345 and having it displayed as 1:23.45 ... As a swimming coach I would find
| this a great help.
|
| Thanks for the insight...
|
| JCJ

 

[Guest]

Try this:
Assuming your data in A1
A1=2345

your formula in B1 =":"&LEFT(A1,2)&"."&RIGHT(A1,2)