Hi Guys,
I have a column of call duration values.
For example:
00:09:54
00:10:11
01:55:07
01:55:23
02:47:24
02:47:39
02:59:35
00:35:22
00:35:50
Is there a way we can roundup to the nearest minute, then represent this as a value, so based upon the example below, these values would now be shown as:
10
11
116
116
168
168
180
36
36
Thanks guys
I have a column of call duration values.
For example:
00:09:54
00:10:11
01:55:07
01:55:23
02:47:24
02:47:39
02:59:35
00:35:22
00:35:50
Is there a way we can roundup to the nearest minute, then represent this as a value, so based upon the example below, these values would now be shown as:
10
11
116
116
168
168
180
36
36
Thanks guys