Re: $$Excel-Macros$$ Time Calcuation

2012-04-16 Thread NOORAIN ANSARI
Dear Deba, Maries solution is nice... You can also use below formula with custom format [h]:mm:ss =($B5-ROUNDDOWN($B5,0))+($C5-ROUNDDOWN($C5,0)) -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Time Calcuation

2012-04-16 Thread Deba Ranjan
*Thanks for the help , its brilliant working. * Thanks & Regards,* * *Deba Ranjan P*** On Mon, Apr 16, 2012 at 12:34 PM, Maries wrote: > Hi, > > Try it, > > =TEXT((B5-INT(B5))+(C5-INT(C5)),"[h]:mm:ss") > > On Mon, Apr 16, 2012 at 10:50 AM, anil panchal wrote: > >> TEXT(B5+C5,"[h]:mm:ss") > > >

Re: $$Excel-Macros$$ Time Calcuation

2012-04-16 Thread Maries
*PFA...* On Mon, Apr 16, 2012 at 11:04 AM, Maries wrote: > Hi, > > Try it, > > =TEXT((B5-INT(B5))+(C5-INT(C5)),"[h]:mm:ss") > > On Mon, Apr 16, 2012 at 10:50 AM, anil panchal wrote: > >> TEXT(B5+C5,"[h]:mm:ss") > > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ Time Calcuation

2012-04-16 Thread Maries
Hi, Try it, =TEXT((B5-INT(B5))+(C5-INT(C5)),"[h]:mm:ss") On Mon, Apr 16, 2012 at 10:50 AM, anil panchal wrote: > TEXT(B5+C5,"[h]:mm:ss") -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ Time Calcuation

2012-04-15 Thread Deba Ranjan
*Hi Experts, Its not working Please do in the sheet please, so that i will clarified. thanks * Thanks & Regards,* * *Deba Ranjan P*** On Mon, Apr 16, 2012 at 12:20 PM, anil panchal wrote: > TEXT(B5+C5,"[h]:mm:ss") > > > On Mon, Apr 16, 2012 at 12:00 PM, Deba Ranjan wrote: > >> *Hi Experts

Re: $$Excel-Macros$$ Time Calcuation

2012-04-15 Thread anil panchal
TEXT(B5+C5,"[h]:mm:ss") On Mon, Apr 16, 2012 at 12:00 PM, Deba Ranjan wrote: > *Hi Experts, > > Please see the attached File. There i am getting error in time > calculation. please do the needful. Thanks in advance. > * > > > Thanks & Regards,* > * > *Deba > > * > > -- > FORUM RULES (986+ member

$$Excel-Macros$$ Time Calcuation

2012-04-15 Thread Deba Ranjan
*Hi Experts, Please see the attached File. There i am getting error in time calculation. please do the needful. Thanks in advance. * Thanks & Regards,* * *Deba * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please