| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Time Conversion Calculation | Excel Worksheet Functions | |||
| Anyone have a GPS Time conversion for excel | Excel Discussion (Misc queries) | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Keyboard shortcuts for time in Pocket Excel | Excel Worksheet Functions | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
Linear Mode
