Re: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread Deba Ranjan
t;> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan >> *Sent:* 04 June 2012 6:48 >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Date form

Re: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread David Grugeon
ajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 04 June 2012 6:48 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Da

RE: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread Rajan_Verma
@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format calculation Sir, i mean the times are like wise: hour, minute, second It can be 2000 hours can be 300 mins can be 200 seconds... Thanks & Regards, Deba Ranjan P On Mon, Jun 4, 2012 at 6:29 PM, Rajan_Verma w

Re: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread Deba Ranjan
t; * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 04 June 2012 9:27 > > *To:* excel-macros@googlegroups.

RE: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread Rajan_Verma
But how can second be 64? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deba Ranjan Sent: 04 June 2012 9:27 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format calculation

RE: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread Asa Rossoff
groups.com Subject: Re: $$Excel-Macros$$ Date format calculation Dear Asa, Can you please explain in the sheet itself. Thanks & Regards, Deba Ranjan P On Mon, Jun 4, 2012 at 1:22 PM, Asa Rossoff wrote: Hi Deba, For the Login Time column, the reason SUM is not working pr

Re: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread Deba Ranjan
Dear Asa, Can you please explain in the sheet itself. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 1:22 PM, Asa Rossoff wrote: > Hi Deba, > > ** ** > > *For the Login Time column,* the reason SUM is not working properly is > that many of the login times are being in

RE: $$Excel-Macros$$ Date format calculation

2012-06-04 Thread Asa Rossoff
Hi Deba, For the Login Time column, the reason SUM is not working properly is that many of the login times are being interpreted as text instead of as [h]:mm:ss entries. 1) For the login time column with a custom format: [h]:mm:ss or the corresponding preset "Time" format: 37:30:55 2)

Re: $$Excel-Macros$$ Date format calculation

2012-06-03 Thread Deba Ranjan
Please have a look on this Dear Experts. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 9:27 AM, Deba Ranjan wrote: > Yes...exactly. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma wrote: > >> Hi >> >> What do you

Re: $$Excel-Macros$$ Date format calculation

2012-06-03 Thread Deba Ranjan
Yes...exactly. Thanks & Regards, *Deba Ranjan P* On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma wrote: > Hi > > What do you mean by this Login time : “879:55:64” is it 879 Hour 55 > Minute and 64 Seconds?? > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [I

RE: $$Excel-Macros$$ Date format calculation

2012-06-03 Thread Rajan_Verma
Hi What do you mean by this Login time : "879:55:64" is it 879 Hour 55 Minute and 64 Seconds?? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deba Ranjan Sent: 02 June 2012 12:39 To: excel-macros@go