RogueSchnitzel
New Member
- Joined
- Jun 15, 2019
- Messages
- 3
Hi Folks,
I'm lost trying to figure out how to aggregate the Time data in the table below to make it easier to work with and more presentable. Unfortunately, I don't have control over how the data is exported and I'm stuck to work with what I got.
Luckily I've found this Forum and I've been searching it for an answer as well as trying to piece together a solution for my dilemma, but no success thus far. Now I'm here, posting and hoping someone can pull me out of this void.
ray:
My Challenge:
The times in table below are reflected as "hh:mm", e.g. E2 = 181:12 (181 hours and 12 minutes)
I would like it to reflect something to this effect "dd:hh:mm" or Decimal, but am open to other suggestions as well.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 79"]Agents
[/TD]
[TD="width: 64"]Tardy[/TD]
[TD="width: 64"]UPTO[/TD]
[TD="width: 70"]NCNS[/TD]
[TD="width: 64"]Total[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD]05:12[/TD]
[TD]176:00[/TD]
[TD]-[/TD]
[TD]181:12[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD]10:05[/TD]
[TD]114:15[/TD]
[TD]-[/TD]
[TD]124:20[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD]24:14[/TD]
[TD]68:45[/TD]
[TD]09:00[/TD]
[TD]101:59[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD]11:59[/TD]
[TD]72:00[/TD]
[TD]03:58[/TD]
[TD]87:57[/TD]
[/TR]
[TR]
[TD]Agent 5[/TD]
[TD]03:13[/TD]
[TD]48:00[/TD]
[TD]-[/TD]
[TD]51:13[/TD]
[/TR]
</tbody>[/TABLE]
This might be something easy, but I can't figure it out for the life of me.
Any help is greatly appreciated and would make my day!!
I'm lost trying to figure out how to aggregate the Time data in the table below to make it easier to work with and more presentable. Unfortunately, I don't have control over how the data is exported and I'm stuck to work with what I got.
Luckily I've found this Forum and I've been searching it for an answer as well as trying to piece together a solution for my dilemma, but no success thus far. Now I'm here, posting and hoping someone can pull me out of this void.


The times in table below are reflected as "hh:mm", e.g. E2 = 181:12 (181 hours and 12 minutes)
I would like it to reflect something to this effect "dd:hh:mm" or Decimal, but am open to other suggestions as well.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 79"]Agents
[/TD]
[TD="width: 64"]Tardy[/TD]
[TD="width: 64"]UPTO[/TD]
[TD="width: 70"]NCNS[/TD]
[TD="width: 64"]Total[/TD]
[/TR]
[TR]
[TD]Agent 1[/TD]
[TD]05:12[/TD]
[TD]176:00[/TD]
[TD]-[/TD]
[TD]181:12[/TD]
[/TR]
[TR]
[TD]Agent 2[/TD]
[TD]10:05[/TD]
[TD]114:15[/TD]
[TD]-[/TD]
[TD]124:20[/TD]
[/TR]
[TR]
[TD]Agent 3[/TD]
[TD]24:14[/TD]
[TD]68:45[/TD]
[TD]09:00[/TD]
[TD]101:59[/TD]
[/TR]
[TR]
[TD]Agent 4[/TD]
[TD]11:59[/TD]
[TD]72:00[/TD]
[TD]03:58[/TD]
[TD]87:57[/TD]
[/TR]
[TR]
[TD]Agent 5[/TD]
[TD]03:13[/TD]
[TD]48:00[/TD]
[TD]-[/TD]
[TD]51:13[/TD]
[/TR]
</tbody>[/TABLE]
This might be something easy, but I can't figure it out for the life of me.

Any help is greatly appreciated and would make my day!!
