| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERT function for Excel 2003
I was trying to format time in decimals to days:hours:mins format. While
using microsoft excel 2003 help, they said to use CONVERT funtion for the same. But there isnt any CONVERT funtion in the Inset menufuntions, in excel 2003. I tried for the same on Excel 2003 installed in other computers as well to confirm, but they didnt have it either. Could anyone explain why? And how could I install the CONVERT funtion on to my Excel 2003? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT function for Excel 2003
Hi
Time is stored as fractions of a day (24 hours). So to convert your data, with decimals hours in cell A1, enter in B1 =A1/24 and format B1 FormatCellNumberCustom d:hh:mm -- Regards Roger Govier Chandrahas wrote: I was trying to format time in decimals to days:hours:mins format. While using microsoft excel 2003 help, they said to use CONVERT funtion for the same. But there isnt any CONVERT funtion in the Inset menufuntions, in excel 2003. I tried for the same on Excel 2003 installed in other computers as well to confirm, but they didnt have it either. Could anyone explain why? And how could I install the CONVERT funtion on to my Excel 2003? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT function for Excel 2003
Load the Analysis Toolpak through ToolsAdd-ins to access CONVERT function.
If you looked up CONVERT in help you would have found that out. Gord Dibben MS Excel MVP On Sun, 30 May 2010 08:27:01 -0700, Chandrahas wrote: I was trying to format time in decimals to days:hours:mins format. While using microsoft excel 2003 help, they said to use CONVERT funtion for the same. But there isnt any CONVERT funtion in the Inset menufuntions, in excel 2003. I tried for the same on Excel 2003 installed in other computers as well to confirm, but they didnt have it either. Could anyone explain why? And how could I install the CONVERT funtion on to my Excel 2003? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
| How do I convert a Excel 2003 file into a Word 2003 file (table)? | Excel Discussion (Misc queries) | |||
| Can I just convert to Word 2003 and Excel 2003? | Excel Discussion (Misc queries) | |||
| WHY WAS THE CONVERT FUNCTION DROPPED IN EXCEL 2003??? | Excel Worksheet Functions | |||
| Convert "1" to "One" in Excel 2003? | Excel Discussion (Misc queries) | |||
Linear Mode
