hi everyone,
i would really appreciate it if someone can help me sort this out please...
i have this machine that logs phone calls made on an internet telephone from the office... it puts them in an excel file... it showes in one column the duration of a call (in this format HH:MM:SS) and the cost total of that call in the column next to it... the billing for the calls is per minute and our boss wants the call durations to be a rounded time (i.e. if the call was 00:06:37 he wants to only see 00:07:00 or say 00:59:23 he wants to see 01:00:00) is there any way at all of doing this automated as there is a log of over 20000 calls over 12 months that i need to manually adjust if not...
any help would be greeeeaaatfullly appreciated...
thanks
KT
i would really appreciate it if someone can help me sort this out please...
i have this machine that logs phone calls made on an internet telephone from the office... it puts them in an excel file... it showes in one column the duration of a call (in this format HH:MM:SS) and the cost total of that call in the column next to it... the billing for the calls is per minute and our boss wants the call durations to be a rounded time (i.e. if the call was 00:06:37 he wants to only see 00:07:00 or say 00:59:23 he wants to see 01:00:00) is there any way at all of doing this automated as there is a log of over 20000 calls over 12 months that i need to manually adjust if not...
any help would be greeeeaaatfullly appreciated...
thanks
KT