Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110204
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Comparison of Time |
| Date | 2017-08-17 19:19 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <on582e$nji$1@dont-email.me> (permalink) |
| References | (4 earlier) <oms36v$kpi$1@dont-email.me> <9fa59044-b6d0-43e1-8068-9870c1ed2049@googlegroups.com> <omuddn$bqm$1@dont-email.me> <70048080-b539-4d44-8795-02deb52506a0@googlegroups.com> <771b64ce-9c0b-44ce-8a07-844e26d209ad@googlegroups.com> |
> On Thursday, 17 August 2017 18:16:18 UTC+5:30, Max wrote: >> On Tuesday, 15 August 2017 14:38:14 UTC+5:30, Claus Busch wrote: >>> Hi Max, >>> >>> Am Tue, 15 Aug 2017 01:40:59 -0700 (PDT) schrieb Max: >>> >>>> WOW, Great....Claus, Thanks you made the solution.. Though I need to learn >>>> on the Sum Product Function as well as MOD Function..... As I am not clear >>>> that why divisor is 3... If you can Explain. >>> >>> you want check every 3rd column. Therefore you have to divide the column >>> number by 3. >>> MOD(COLUMN(B3:CR3),3)=2 >>> is true for columns 2, 5, 8, 11 and so on. >>> >>> >>> Regards >>> Claus B. >>> -- >>> Windows10 >>> Office 2016 >> >> Hi Claus, I am sorry to Trouble you again... Please have a look on this and >> can you tell me where I am Wrong please? >> >> https://1drv.ms/x/s!AtAG_WNGGJX3gQbqM_6963w0n-sl > > Also My Time is copy pasted from a Text....The Time format is in Text form > from the Punch Machine output file and I my formula also puts value as > text... If I will change the Full selection to Time Format it doesn't do the > same but after words I have to select each and every cell and then Press 'F2' > and 'Enter' and then the Format changes to the desired one... Even the > Conditional formatting also works after I select and change every cell... > > Is there any bug in my system or it's normal behavior of the Excel? >> >> Thanks & Regards, >> Max Why copy/paste when you can read the file via standard VBA I/O functions and convert from text while populating the time cells?? In this day and age where time is so much in demand for the workload we have on our plate, it just makes sense to automate repetitive tasks to the nines so we yield a higher level of productivity!!! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-13 12:03 -0700
Re: Comparison of Time "Auric__" <not.my.real@email.address> - 2017-08-13 23:05 +0000
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-13 23:52 -0700
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-14 00:09 -0700
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-08-14 14:01 +0200
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-15 01:40 -0700
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-08-15 11:08 +0200
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-15 04:21 -0700
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-08-15 08:23 -0700
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-15 22:35 -0700
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-08-16 05:46 -0700
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-17 05:46 -0700
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-17 06:04 -0700
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-08-17 15:18 +0200
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-17 06:50 -0700
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-08-17 15:53 +0200
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-08-17 09:57 -0700
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-08-17 19:00 +0200
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-08-18 22:07 -0700
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-21 00:16 -0700
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-21 03:26 -0700
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-08-21 12:34 +0200
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-08-21 07:58 -0700
Re: Comparison of Time Max <mukeshoza99@gmail.com> - 2017-08-21 22:24 -0700
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-09-01 23:03 -0700
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-09-02 09:12 +0200
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-09-02 11:31 -0700
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-09-04 19:09 -0700
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-09-04 20:18 -0700
Re: Comparison of Time TIMOTHY <jey.kumar87@gmail.com> - 2017-09-05 02:52 -0700
Re: Comparison of Time GS <gs@v.invalid> - 2017-08-17 19:19 -0400
Re: Comparison of Time GS <gs@v.invalid> - 2017-08-13 20:18 -0400
Re: Comparison of Time GS <gs@v.invalid> - 2017-08-14 07:27 -0400
Re: Comparison of Time Claus Busch <claus_busch@t-online.de> - 2017-08-14 08:16 +0200
csiph-web