Agent schedule based on timestamp

R

rniculae

New Member
Joined
Apr 9, 2013
Messages
41
Hello guys,

I've been struggling lately to find a way to show up on a wallboard what was the availability of our agents during a day based on their timestamp statuses.
I am using Cisco UCCX and I can get a report named Agent State Detail which provides me agent name, Time when status change occurred and for how long he stayed in that status.

I wanted to have a chart where on Vertical Axis I would have 12:00 AM to 12:00 AM next day and based on their status occurrence and for how long they have been on that status shown on a stacked column or something that would be helpful for management and on Horizontal Axis agent names.

I would really appreciate your help. Unfortunately I cannot add an excel file but I will try to create a CODE table.

I added 4 agents with their status during 9/21/2017 12:00 AM to 9/22/2017 12:00 AM and my table starts on A1.
Thank you very much!

Razvan

Code: 
[TABLE="width: 368"]
<tbody>[TR]
[TD]Agent[/TD]
[TD]State Transition Time[/TD]
[TD]Agent State[/TD]
[TD]Duration[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  3:33:00 PM[/TD]
[TD]Logged-in[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  3:33:00 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:11:26[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  3:44:26 PM[/TD]
[TD]Ready[/TD]
[TD]0:21:52[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  4:06:18 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:14:36[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  4:20:54 PM[/TD]
[TD]Ready[/TD]
[TD]0:12:06[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  4:33:00 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:18:19[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  4:51:19 PM[/TD]
[TD]Ready[/TD]
[TD]0:46:26[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  5:37:45 PM[/TD]
[TD]Reserved[/TD]
[TD]0:00:08[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  5:37:53 PM[/TD]
[TD]Talking[/TD]
[TD]0:00:06[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  5:37:59 PM[/TD]
[TD]Ready[/TD]
[TD]0:31:57[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  6:09:56 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:49:47[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  6:59:43 PM[/TD]
[TD]Ready[/TD]
[TD]0:03:13[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  7:02:56 PM[/TD]
[TD]Reserved[/TD]
[TD]0:00:06[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  7:03:02 PM[/TD]
[TD]Talking[/TD]
[TD]0:03:09[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  7:06:11 PM[/TD]
[TD]Ready[/TD]
[TD]0:16:17[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  7:22:28 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:08:15[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  7:30:43 PM[/TD]
[TD]Ready[/TD]
[TD]0:01:00[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  7:31:43 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:04:34[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  7:36:17 PM[/TD]
[TD]Ready[/TD]
[TD]0:25:54[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:02:11 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:21[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:02:32 PM[/TD]
[TD]Ready[/TD]
[TD]0:00:18[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:02:50 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:02[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:02:52 PM[/TD]
[TD]Ready[/TD]
[TD]0:00:09[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:03:01 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:18[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:03:19 PM[/TD]
[TD]Ready[/TD]
[TD]0:03:05[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:06:24 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:28:38[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:35:02 PM[/TD]
[TD]Ready[/TD]
[TD]0:21:17[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:56:19 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:55[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  8:57:14 PM[/TD]
[TD]Ready[/TD]
[TD]0:08:51[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  9:06:05 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:03:16[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  9:09:21 PM[/TD]
[TD]Ready[/TD]
[TD]0:05:29[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  9:14:50 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:10:33[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  9:25:23 PM[/TD]
[TD]Ready[/TD]
[TD]0:41:14[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  10:06:37 PM[/TD]
[TD]Reserved[/TD]
[TD]0:00:06[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  10:06:43 PM[/TD]
[TD]Talking[/TD]
[TD]0:07:01[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  10:13:44 PM[/TD]
[TD]Ready[/TD]
[TD]0:33:39[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  10:47:23 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:10:57[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  10:58:20 PM[/TD]
[TD]Ready[/TD]
[TD]0:09:19[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  11:07:39 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:01:06[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  11:08:45 PM[/TD]
[TD]Ready[/TD]
[TD]0:06:00[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  11:14:45 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:19:33[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  11:34:18 PM[/TD]
[TD]Ready[/TD]
[TD]0:11:11[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  11:45:29 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:14:26[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD="align: right"]9/21/2017  11:59:55 PM[/TD]
[TD]Logout[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  4:22:11 PM[/TD]
[TD]Logged-in[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  4:22:11 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:30[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  4:22:41 PM[/TD]
[TD]Ready[/TD]
[TD]0:10:26[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  4:33:07 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:45:22[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  5:18:29 PM[/TD]
[TD]Ready[/TD]
[TD]0:28:14[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  5:46:43 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:38:45[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  6:25:28 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:56:44[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  7:22:12 PM[/TD]
[TD]Ready[/TD]
[TD]0:17:56[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  7:40:08 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:03:04[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  7:43:12 PM[/TD]
[TD]Ready[/TD]
[TD]0:13:29[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  7:56:41 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:03:05[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  7:59:46 PM[/TD]
[TD]Ready[/TD]
[TD]0:03:27[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  8:03:13 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:07:02[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  8:10:15 PM[/TD]
[TD]Ready[/TD]
[TD]01:04:54[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  9:15:09 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:11:15[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  9:26:24 PM[/TD]
[TD]Ready[/TD]
[TD]0:16:50[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  9:43:14 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:37:55[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  10:21:09 PM[/TD]
[TD]Ready[/TD]
[TD]0:08:38[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  10:29:47 PM[/TD]
[TD]Logout[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  11:55:09 PM[/TD]
[TD]Logged-in[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  11:55:09 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:45[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  11:55:54 PM[/TD]
[TD]Ready[/TD]
[TD]0:00:22[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD="align: right"]9/21/2017  11:56:16 PM[/TD]
[TD]Logout[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  1:05:23 PM[/TD]
[TD]Logged-in[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  1:05:23 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:47[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  1:06:10 PM[/TD]
[TD]Ready[/TD]
[TD]0:02:57[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  1:09:07 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:23:15[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  1:32:22 PM[/TD]
[TD]Ready[/TD]
[TD]0:35:18[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  2:07:40 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:17:00[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  2:24:40 PM[/TD]
[TD]Ready[/TD]
[TD]0:24:42[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  2:49:22 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:02:48[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  2:52:10 PM[/TD]
[TD]Ready[/TD]
[TD]0:36:48[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  3:28:58 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:12:04[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  3:41:02 PM[/TD]
[TD]Ready[/TD]
[TD]0:34:37[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  4:15:39 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:02:14[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  4:17:53 PM[/TD]
[TD]Ready[/TD]
[TD]0:21:19[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  4:39:12 PM[/TD]
[TD]Reserved[/TD]
[TD]0:00:05[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  4:39:17 PM[/TD]
[TD]Talking[/TD]
[TD]0:12:22[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  4:51:39 PM[/TD]
[TD]Ready[/TD]
[TD]0:03:00[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  4:54:39 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:06:57[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  5:01:36 PM[/TD]
[TD]Logout[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  5:29:59 PM[/TD]
[TD]Logged-in[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  5:29:59 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:31[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  5:30:30 PM[/TD]
[TD]Ready[/TD]
[TD]0:03:57[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  5:34:27 PM[/TD]
[TD]Not Ready[/TD]
[TD]02:00:41[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  7:35:08 PM[/TD]
[TD]Ready[/TD]
[TD]0:05:51[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  7:40:59 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:18:03[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  7:59:02 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:35:36[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  8:34:38 PM[/TD]
[TD]Ready[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  8:34:38 PM[/TD]
[TD]Reserved[/TD]
[TD]0:00:01[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  8:34:39 PM[/TD]
[TD]Talking[/TD]
[TD]0:04:03[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  8:38:42 PM[/TD]
[TD]Ready[/TD]
[TD]0:16:52[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  8:55:34 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:09:30[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD="align: right"]9/21/2017  9:05:04 PM[/TD]
[TD]Logout[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  3:53:07 PM[/TD]
[TD]Logged-in[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  3:53:07 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:01:19[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  3:54:26 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:22:46[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  4:17:12 PM[/TD]
[TD]Ready[/TD]
[TD]01:20:18[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  5:37:30 PM[/TD]
[TD]Reserved[/TD]
[TD]0:00:15[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  5:37:45 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:00:40[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  5:38:25 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:12:49[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  5:51:14 PM[/TD]
[TD]Ready[/TD]
[TD]01:49:29[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  7:40:43 PM[/TD]
[TD]Logout[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  8:35:38 PM[/TD]
[TD]Logged-in[/TD]
[TD]0:00:00[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  8:35:38 PM[/TD]
[TD]Not Ready[/TD]
[TD]0:03:37[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  8:39:15 PM[/TD]
[TD]Ready[/TD]
[TD]02:13:32[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  10:52:47 PM[/TD]
[TD]Reserved[/TD]
[TD]0:00:11[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  10:52:58 PM[/TD]
[TD]Talking[/TD]
[TD]0:00:51[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD="align: right"]9/21/2017  10:53:49 PM[/TD]
[TD]Ready[/TD]
[TD]01:06:11[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Sort by date Sort by votes
Hello,

I saw that this thread went to page 15+ in a day... I just wanted to give it a bump and maybe someone can help me with this.

Thanks,
Razvan
 
Upvote 0
Hello,

Let's say that I won't want the chart done 100% but maybe some hints or tips on how to do it.

Please help me out :)

Thanks
R
 
Upvote 0
Hello,

Can someone just say something? It's too hard to do it or it's just too much work involved?

Thanks
Razvan
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
sumifs using date and time values
Replies
9
Views
242
Asbestos_Jen
Asbestos_Jen
B
  • Solved
Possible to pull apart 1st section of string for date & time
2 3
Replies
23
Views
437
Peter_SSs
Peter_SSs
A
  • Question Question
Hi. I'm trying to fill 1 for the time between arrival and departure.
Replies
1
Views
159
Asbestos_Jen
Asbestos_Jen
J
  • Solved
Excel Formula to highlight most recent record
Replies
3
Views
396
etaf
etaf
F
  • Question Question
Enhance simply subtract of date/times of time spent, to including indexing and subtracting time blocked from another table (with multiple criteria)
Replies
0
Views
388
freeb1893
F

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top