I wish to calculate the chargeable minutes that would have applied to bills over the last year, had I not opted for an "all in" package.
By way of example the latest month's statistic have 8 calls of total duration (hh:mm:ss) 00:36:31, which when divided by 8 becomes
00:04:34. Because the seconds are greater than 0 the answer should be 00:05:00. What formula need I apply, so that items containing 0 seconds are not rounded up too?
By way of example the latest month's statistic have 8 calls of total duration (hh:mm:ss) 00:36:31, which when divided by 8 becomes
00:04:34. Because the seconds are greater than 0 the answer should be 00:05:00. What formula need I apply, so that items containing 0 seconds are not rounded up too?
