Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110248

Re: Comparison of Time

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: Comparison of Time
Date 2017-09-02 09:12 +0200
Organization A noiseless patient Spider
Message-ID <oodlcl$s9j$1@dont-email.me> (permalink)
References (12 earlier) <b6bfff06-4c0e-4354-9cdc-31a20e93b1a7@googlegroups.com> <3952fc46-c8df-4492-bca5-4696134cfc45@googlegroups.com> <oneco3$qli$1@dont-email.me> <8fc62f4b-5c19-4c74-b7de-7072fee6def4@googlegroups.com> <8b16500c-6ba8-4696-8182-69ecdce763fe@googlegroups.com>

Show all headers | View raw

Hi,

Am Fri, 1 Sep 2017 23:03:58 -0700 (PDT) schrieb TIMOTHY:

> I want to only consider in time (first entry) & out time (last entry) 
> Next date would be below this & same logic like this. 
> 
> Local Time
> 7/3/2017 9:02:47 AM
> 7/3/2017 9:06:16 AM
> 7/3/2017 10:41:11 AM
> 7/3/2017 11:51:03 AM
> 7/3/2017 12:59:55 PM
> 7/3/2017 2:13:45 PM
> 7/3/2017 2:50:31 PM
> 7/3/2017 4:23:39 PM
> 7/3/2017 4:23:50 PM
> 7/3/2017 4:29:37 PM
> 7/3/2017 4:33:22 PM
> 7/3/2017 5:56:57 PM
> 7/3/2017 6:04:10 PM

try:
=MAX(IF(INT(A2:A100)=INT(A2),A2:A100))-A2
and insert the formula with CTRL+Shift+Enter


Regards
Claus B.
-- 
Windows10
Office 2016

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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