Prev: Source and Destination worksheet difference
Next: moving multiple data in a cell to other columns
From: Chandrahas on 30 May 2010 11:27
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 menu>funtions, 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?
From: Roger Govier on 30 May 2010 11:35
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 Format>Cell>Number>Custom> 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 menu>funtions, 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?
From: Gord Dibben on 30 May 2010 11:51
Load the Analysis Toolpak through Tools>Add-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
<Chandrahas(a)discussions.microsoft.com> 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 menu>funtions, 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?

 | 
Pages: 1
Prev: Source and Destination worksheet difference
Next: moving multiple data in a cell to other columns