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
r) > > ** ** > > *For the Login time for 1 day… cell* (F5), I don't really understand the > formula or what you want, but perhaps the formula is correct and you just > need to format the result for time: > > [h]:mm:ss > > ** ** > >

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

2012-06-04 Thread Asa Rossoff
f Deba Ranjan Sent: Saturday, June 02, 2012 12:09 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date format calculation Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Pl

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

2012-06-03 Thread Deba Ranjan
M-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@googlegroups.com >> *Subject:* $$Excel-Macros$$ Date format ca

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

2012-06-03 Thread Deba Ranjan
; > *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@googlegroups.com > *Subject:* $$Excel-Macros

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

2012-06-03 Thread Rajan_Verma
cel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date format calculation Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Please help in calculating the problem. Thanks &

$$Excel-Macros$$ Date format calculation

2012-06-02 Thread Deba Ranjan
Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Please help in calculating the problem. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation