In spreadsheet i have more than 5 columns, every columns showing its own value. One of the column shows the talk time as follows,
60:00
06:44
08:48
59:13
I just want to round up this values, as follows.
60
07
09
59
For example 01:25
If the talktime is equal to & above 25seconds it should be rounded as 02
but if the talktime is 01:13
then it should round it as 01
and not as 02
.