Hi,
I have a column called "duration", which shows the length of a phone call made. It has been given to me in the format of hh:mm:ss, so that 00:00:35 means a 35 second call, 00:15:42 is a 15 minutes and 42 second call etc.
In essence, though, because of the format being a time format, these numbers really mean 12:00:35 am and 12:15:42 am, that is, a time of day.
I need to convert 00:00:35 into "35 seconds", and then round up to the nearest minute. So in this example, 00:00:35 should equal 1 and 00:15:42 should equal 16.
The roundup function is not working due to the numbers being in time format and I am out of ideas on how to convert seconds into whole numbers.
Is there any easy way to do this? Any ideas? Thanks in advance.
I have a column called "duration", which shows the length of a phone call made. It has been given to me in the format of hh:mm:ss, so that 00:00:35 means a 35 second call, 00:15:42 is a 15 minutes and 42 second call etc.
In essence, though, because of the format being a time format, these numbers really mean 12:00:35 am and 12:15:42 am, that is, a time of day.
I need to convert 00:00:35 into "35 seconds", and then round up to the nearest minute. So in this example, 00:00:35 should equal 1 and 00:15:42 should equal 16.
The roundup function is not working due to the numbers being in time format and I am out of ideas on how to convert seconds into whole numbers.
Is there any easy way to do this? Any ideas? Thanks in advance.
