| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
16.36 convert to 16:36 (min:sec)
I imported a column of min:sec data from Crystal reports XI. However when I
open in Excel, Excel has dropped the : and substituted a . Hence as an example what should be 16:36 (min:sec) shows in Excel as 16.36 How can I convert something like 16.36 to min:sec? And secondly, how could I convert 16.36 to a true minutes and hundreths of a minute? Any help appreciated! Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert number to its letters ( convert "1" to "One" ) | Excel Discussion (Misc queries) | |||
| how do i convert Min:Sec to Min.sec for example 68:43:00 = 68.43 | New Users to Excel | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
