n decimal format".
> But the example you gave is NOT what I would consider the decimal format of
> time.
> because to ME, 3:48 is NOT the equivalent of 3.48
>
> Take a look at the answers you've been given and see if they help you
> toward the results you require...
>
Thanks a lot Srinivasan, siti, Paul and P. VijayKumar
Regards,
Vijay
On Fri, Oct 15, 2010 at 5:28 AM, P.VIJAYKUMAR wrote:
> Dear Vijay
>
> After slecting your required data go to Format menu in that there are a
> number of formats.In the last there is Custom Format,By selecting that you
> ca
Dear Vijay
After slecting your required data go to Format menu in that there are a
number of formats.In the last there is Custom Format,By selecting that you
can specify your own format.In that specify the format you want to have your
data,Your data will be changed to the format you wanted.
Reg
e decimal format of
time.
because to ME, 3:48 is NOT the equivalent of 3.48
Take a look at the answers you've been given and see if they help you toward
the
results you require...
Paul
>
>From: Vijay Kr. Aggarwal
>To: excel-macros@googlegroups.com
>Sent: Thu, October
just multiply by 24
time 3:48 in cell A1
=A1*24
resulting: 3.80
that is equal to:3 + 48/60
not 4.48
CMIIW
On Fri, Oct 15, 2010 at 10:55 AM, Vijay Kr. Aggarwal <
vjaggarwal2...@gmail.com> wrote:
> Hi Friends,
> Please let me know that how can I write time in decimal format.
> Time :
On Fri, Oct 15, 2010 at 9:25 AM, Vijay Kr. Aggarwal <
vjaggarwal2...@gmail.com> wrote:
> Hi Friends,
>
> Please let me know that how can I write time in decimal format.
>
> Time :- 3:48 (3 hours 48 mins) then it should show 3.48
>
> Thanks in advance
>
> Regards,
> Vijay
>
> --
>
> ---
Hi Friends,
Please let me know that how can I write time in decimal format.
Time :- 3:48 (3 hours 48 mins) then it should show 3.48
Thanks in advance
Regards,
Vijay
--
--
Some important links for excel users:
1. F
