My phone provider charges me in 90 second block increments. I need a formula to calculate how many 90 second blocks are in a 93 second call duration.
I already know how many seconds each call was...
etc..
CALL DURATION - BLOCKS
93 - 2
85 - 1
10 - 1
188 - 3
Last edited by benjamind11; 01-23-2013 at 09:49 AM.
If you call durations start in A1 then something like this, perhaps:
=ROUNDUP(A1/90,0)
Boom! Thank you Andrew-R..
Another also works:
=CEILING(A1,90)/90
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks