1 Reply Latest reply on Dec 26, 2018 9:39 AM by Patrick Van Der Hyde

    Time and Date Calculation

    joy.delosreyes

      Hi experts!

      I need some help in calculating time and date.

       

      I'm having a hard time calculating for shifts and total time an employee is in each rooms.

       

      DateTimeRoomCalculationActivityName
      October 01, 201820:28:14Break RoomValid Card EntryEmployee6
      October 01, 201820:41:02Break RoomValid Card EntryEmployee6
      October 01, 201820:46:14Break RoomValid Card EntryEmployee6
      October 01, 201820:49:59Door-IN0:21:45BreakroomValid Card EntryEmployee6
      October 01, 201820:50:09Prod0:00:10Door-inValid Card EntryEmployee6
      October 01, 201821:42:57Door-OUT0:52:48ProdValid Card ExitEmployee6
      October 01, 201821:43:05Break Room0:00:08Door-outValid Card EntryEmployee6
      October 01, 201821:50:25Door-IN0:07:20BreakroomValid Card EntryEmployee6
      October 01, 201821:50:34Prod0:00:09Door-inValid Card EntryEmployee6
      October 01, 201823:03:53Door-OUT1:13:19ProdValid Card ExitEmployee6
      October 01, 201823:04:00Break Room0:00:07Door-outValid Card EntryEmployee6
      October 01, 201823:08:58Door-IN0:04:58BreakroomValid Card EntryEmployee6
      October 01, 201823:09:08Prod0:00:10Door-inValid Card EntryEmployee6
      October 01, 201823:09:22Prod0:00:14ProdValid Card EntryEmployee6
      October 01, 201823:30:06Door-OUT0:20:44ProdValid Card ExitEmployee6
      October 01, 201823:30:14Break Room0:00:08Door-outValid Card EntryEmployee6
      October 01, 201823:43:27Door-IN0:13:13BreakroomValid Card EntryEmployee6
      October 01, 201823:43:36Prod0:00:09Door-inValid Card EntryEmployee6
      October 02, 20180:46:05Door-OUT1:02:29ProdValid Card ExitEmployee6
      October 02, 20180:48:34Door-IN0:02:29Door-OUTValid Card EntryEmployee6
      October 02, 20180:48:45Prod0:00:11Door-INValid Card EntryEmployee6
      October 02, 20181:00:17Door-OUT0:11:32ProdValid Card ExitEmployee6
      October 02, 20181:00:28Break Room0:00:11Door-OUTValid Card EntryEmployee6
      October 02, 20181:43:48Break Room0:43:20Break RoomValid Card EntryEmployee6
      October 02, 20181:57:46Door-IN0:13:58Break RoomValid Card EntryEmployee6
      October 02, 20181:58:48Prod0:01:02Door-INValid Card EntryEmployee6
      October 02, 20182:32:55Door-OUT0:34:07ProdValid Card ExitEmployee6
      October 02, 20182:33:04Break Room0:00:09Door-OUTValid Card EntryEmployee6
      October 02, 20182:40:40Door-IN0:07:36Break RoomValid Card EntryEmployee6
      October 02, 20182:40:50Prod0:00:10Door-INValid Card EntryEmployee6
      October 02, 20183:28:37Door-OUT0:47:47ProdValid Card ExitEmployee6
      October 02, 20183:30:15Door-IN0:01:38Door-OUTValid Card EntryEmployee6
      October 02, 20183:30:26Prod0:00:11Door-INValid Card EntryEmployee6
      October 02, 20184:30:26Door-OUT1:00:00ProdValid Card ExitEmployee6
      October 02, 20184:30:34Break Room0:00:08Door-OUTValid Card EntryEmployee6
      October 02, 20184:43:34Door-IN0:13:00Break RoomValid Card EntryEmployee6
      October 02, 20184:43:45Prod0:00:11Door-INValid Card EntryEmployee6
      October 02, 20184:52:03Door-OUT0:08:18ProdValid Card ExitEmployee6
      October 02, 20184:52:09Break Room0:00:06Door-OUTValid Card EntryEmployee6
      October 02, 20184:52:35Door-IN0:00:26Break RoomValid Card EntryEmployee6
      October 02, 20184:52:43Prod0:00:08Door-INValid Card EntryEmployee6
      October 02, 20185:41:50Door-OUT0:49:07ProdValid Card ExitEmployee6
      October 02, 20185:41:57Break Room0:00:07Door-OUTValid Card EntryEmployee6
      October 02, 20185:45:23Door-IN0:03:26Break RoomValid Card EntryEmployee6
      October 02, 20185:45:35Prod0:00:12Door-INValid Card EntryEmployee6
      October 02, 20186:00:07Door-OUT0:14:32ProdValid Card ExitEmployee6
      October 02, 20186:00:14Break Room0:00:07Door-OUTValid Card EntryEmployee6

       

       

      Please disregard calculation. I just calculated it using excel.

       

      I need to know how to get the following using tableau:

      129 minutes in Breakroom

      2 mins Door in

      5 mins door out

      434 mins prod

       

      I'm having a hard time calculating working time if an employee works night shift.

       

      I really appreciate any help.

      Thank you.

      J