see att.
Tom
On Thu, 10 Mar 2011 20:25:35 +0530, Rajesh K R wrote:
Hi Ashish
Thanks for the reply, I need some more change in it, Kindly check the
attachment .
Regards
Rajesh Kainikkara
On 3/8/11, ashish koul wrote:
see if it helps
On Mon, Mar 7, 2011 at 9:52 PM, Rajesh K R
wrote:
Hi E
Hi Ashish
Thanks for the reply, I need some more change in it, Kindly check the
attachment .
Regards
Rajesh Kainikkara
On 3/8/11, ashish koul wrote:
> see if it helps
>
> On Mon, Mar 7, 2011 at 9:52 PM, Rajesh K R
> wrote:
>
>> Hi Experts ,
>>
>> Kindly check the attached file and tell how to
h K R
To: excel-macros@googlegroups.com
Sent: Tue, March 8, 2011 10:16:48 AM
Subject: Re: $$Excel-Macros$$ Calculate Time
Hi Paul
You give me excellent answer thank you very much, but when I give the
formula timevalue(substitute(d2,".","")) it shows error value #value!.
pls
uot;:")))
> - (C2+TIMEVALUE(SUBSTITUTE(D2,".",":"))))*24
>
> --
> Now, if the time value does NOT represent hh:mm, then we'll have to do
> somethin
gt;
> ----------
> Now, if the time value does NOT represent hh:mm, then we'll have to do
> something
> else to convert it to a fraction of a day.
> (like: D2/24 ??)
>
> hope this helps,
>
> Paul
>
> ---
see if it helps
On Mon, Mar 7, 2011 at 9:52 PM, Rajesh K R wrote:
> Hi Experts ,
>
> Kindly check the attached file and tell how to calculate the hours of
> stay in column "I".
>
> Regards
>
> Rajesh kainikkara
>
> --
>
> ---
---
Now, if the time value does NOT represent hh:mm, then we'll have to do something
else to convert it to a fraction of a day.
(like: D2/24 ??)
hope this helps,
Paul
From: Rajesh K R
To: excel-macros
Sent: Mon, March 7, 2011 11:22:53 AM
Subject: $$Excel-
1 11:22:53 AM
Subject: $$Excel-Macros$$ Calculate Time
Hi Experts ,
Kindly check the attached file and tell how to calculate the hours of
stay in column "I".
Regards
Rajesh kainikkara
--
--
Some impor
Hi Experts ,
Kindly check the attached file and tell how to calculate the hours of
stay in column "I".
Regards
Rajesh kainikkara
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks a
