Re: $$Excel-Macros$$ Pls convert time to given format

2013-09-25 Thread अनिल नारायण गवली
Dear Friends, I got the solution. Thanks Aamir for giving your idea Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Wed, Sep 25, 2013 at 1:02 PM, Aamir Shahzad wrote: > you can use this formula > > =TEXT(A12,"h

Re: $$Excel-Macros$$ Pls convert time to given format

2013-09-25 Thread Aamir Shahzad
you can use this formula =TEXT(A12,"hhmm") On Wed, Sep 25, 2013 at 12:13 PM, अनिल नारायण गवली wrote: > Dear Friends, > > i have to convert the time to given format . format is as follows. > > Time Output > 08:590859 > 17:001700 > 15:30 1530 > 17:05& so on. > 13:12 > 00:00

$$Excel-Macros$$ Pls convert time to given format

2013-09-25 Thread अनिल नारायण गवली
Dear Friends, i have to convert the time to given format . format is as follows. Time Output 08:590859 17:001700 15:30 1530 17:05& so on. 13:12 00:00 08:57 17:15 08:55 17:10 Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Are y