You're welcome Harry. :-)
On Thu, Mar 11, 2010 at 11:34 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> AJ,
>
> Thanks, this is exactly what i was looking for
>
> Thanks
>
> Harry
>
> On Mar 7, 10:53 pm, Abhishek Jain wrote:
> > Dear Harpreet,
> >
> > Check the sample file attache
AJ,
Thanks, this is exactly what i was looking for
Thanks
Harry
On Mar 7, 10:53 pm, Abhishek Jain wrote:
> Dear Harpreet,
>
> Check the sample file attached. Format used is - "[h]:mm" (without quotes).
>
> Cheers!
>
> AJ
>
> On Sun, Mar 7, 2010 at 12:42 PM, Harpreet Singh Gujral <
>
>
>
> harp
Dear Harpreet,
Check the sample file attached. Format used is - "[h]:mm" (without quotes).
Cheers!
AJ
On Sun, Mar 7, 2010 at 12:42 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Ayush,
>
> I tried your solution, it works to some extent, but it doesnt work if
> the date and time
right click on cell click on format cell-> choose the custom format -> nad
type this [hh]:mm
On Sun, Mar 7, 2010 at 12:42 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
> Ayush,
>
> I tried your solution, it works to some extent, but it doesnt work if
> the date and time in B1, is
Hi Frnds,
i also have same Query
As mentioned i tried for the B1-A1 but its not working.as it contains
date and time also,one of my frnd has made macro for the same.i wil gv
it to u tomorrow.
On 3/6/10, Ayush wrote:
> Hi Harpreet,
>
> Simply you can use B1-A1 and change th
Ayush,
I tried your solution, it works to some extent, but it doesnt work if
the date and time in B1, is more by 24 hours.
Can you check on my behalf:
1) 11/12/2009 09:00 and 11/12/2009 10:00
2) 11/12/2009 09:00 and 11/12/2009 14:00
3) 11/12/2009 09:00 and 12/12/2009 09:00
The first date goes in
Hi Harpreet,
Simply you can use B1-A1 and change the time format to "1:00". It
should work.
Let us know if you have any further questions.
Best regards,
Ayush Jain
On Mar 6, 3:38 pm, Harpreet Singh Gujral
wrote:
> Hi Group,
>
> I have the following question:
>
> I have two cells, both have the
