ExcelBanter - Time conversion in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time conversion in Excel (https://www.excelbanter.com/excel-worksheet-functions/118792-time-conversion-excel.html)

JCJimmie

Time conversion in 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

Niek Otten

Time conversion in Excel

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JCJimmie" wrote in message ...
|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

Teethless mama

Time conversion in Excel

Try this:
Assuming your data in A1
A1=2345

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

"JCJimmie" wrote:

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

All times are GMT +1. The time now is 04:55 PM.