Comparison of Time
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
|