Results 1 to 2 of 2

Thread: Need help on calculating time difference from Entry and Exit attendance log

  1. #1

    Need help on calculating time difference from Entry and Exit attendance log



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi, I'm looking for a formula for finding the time spent away from desk. Can someone help. I need to know how much time was spent outside. Below is the sample log

    9/1/2017 00:40:01 Exit granted
    9/1/2017 00:44:11 Entry granted
    9/1/2017 01:10:36 Exit granted
    9/1/2017 01:19:11 Entry granted
    9/1/2017 01:20:21 Exit granted
    9/1/2017 01:38:30 Entry granted
    9/1/2017 01:46:42 Exit granted
    9/1/2017 01:50:03 Entry granted
    9/1/2017 02:49:09 Exit granted
    9/1/2017 02:59:28 Entry granted
    9/1/2017 03:11:00 Exit granted
    9/1/2017 03:12:58 Entry granted
    9/1/2017 03:16:22 Exit granted
    9/1/2017 03:20:44 Entry granted
    9/1/2017 03:42:37 Exit granted
    9/1/2017 18:53:53 Entry granted
    9/1/2017 19:03:36 Exit granted
    9/1/2017 19:03:44 Entry granted
    9/1/2017 19:03:55 Exit granted
    9/1/2017 19:24:48 Entry granted
    9/1/2017 19:31:29 Exit granted
    9/1/2017 19:38:11 Entry granted
    9/1/2017 19:38:30 Exit granted
    9/1/2017 20:12:19 Entry granted
    9/1/2017 20:31:15 Exit granted
    9/1/2017 20:49:09 Entry granted
    9/1/2017 22:30:03 Exit granted
    9/1/2017 22:32:40 Entry granted
    9/1/2017 23:15:42 Exit granted
    9/1/2017 23:30:13 Entry granted
    9/2/2017 00:57:39 Exit granted
    9/2/2017 00:57:45 Entry granted
    9/2/2017 00:58:18 Exit granted

  2. #2
    Acolyte retired007geek's Avatar
    Join Date
    Jun 2017
    Location
    South Carolina, USA
    Posts
    86
    Articles
    0
    How about A2-A1 and format as military time.

    Click image for larger version. 

Name:	AwayTime.PNG 
Views:	13 
Size:	21.2 KB 
ID:	7524

    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •