johninbrisbane
New Member
- Joined
- Mar 4, 2002
- Messages
- 2
The problem is simple. I have a list of telephone call durations with colon format in minutes in seconds, e.g. 2:11 or 127:59. What is the easiest way in Office 97 to decimalise these durations so that I can then multiply by a cost per minute to calculate the resultant call cost. Currently I am using FIND and REPLACE to convert ':' to '.' and then using a combination of INTEGER and REMAINDER functions to do this.
I guess that I could use a STRING function to modify the the third character from the right, as opposed to a global REPLACE for the whole column.
I was hoping that MS may already have a built in function to decimalise minutes and seconds - bit I can't locate it.
Regards, John
I guess that I could use a STRING function to modify the the third character from the right, as opposed to a global REPLACE for the whole column.
I was hoping that MS may already have a built in function to decimalise minutes and seconds - bit I can't locate it.
Regards, John