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 abhishek@gmail.com wrote:
Dear Harpreet,
Check the sample file
AJ,
Thanks, this is exactly what i was looking for
Thanks
Harry
On Mar 7, 10:53 pm, Abhishek Jain abhishek@gmail.com 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
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 jainayus...@gmail.com wrote:
Hi Harpreet,
Simply you can use
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 more by