Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110172
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Comparison of Time |
| Date | 2017-08-13 20:18 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <omqq02$hcu$1@dont-email.me> (permalink) |
| References | <5961cf83-5d76-4812-9c2c-4cd3a8a29650@googlegroups.com> |
> I have to report employees total numbers of In time punch that are after > 09:00 hours and number of Out time before say 18:00 hours in a month say > total 50 employees and for 30 days of a month... Is there a easy way with the > help of VBA to achieve this.. > > my data is like this > 01-Aug-17 > Employee In_Time Out_Time Minutes > 1 9:35 18:00 505 > 2 9:20 17:58 > 3 9:15 19:15 > > Thanks, This formula works if elapsed time passes midnight... =IF(AND(Start<>"",Stop<>""),ROUND(MOD(Stop-Start,1)*24,2),"") ..where 'Start' and 'Stop' are the defined name equivalent of your In_Time and Out_Time, respectively. -- 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