I exported a file from a telephone switch reporting system as a "tab separated text" file, because when I export the data in
Excel I have to deal with merged cells and other formatting problems.
I have a couple of columns that have time
values like 160:02:05 for logged in time, and 34:16:46 as the waiting time… Both are time “DURATIONS” or time in a telephone
I used the Format, Cell, custom and [ss] to get the Time?? value to seconds, and I get 123406 and
576125 respectively. The 1338 is the number of telephone calls handled in the 160+ hours.
I then use these numbers
in a calculation. This calculation looks like this: 1338 / ((576125 - 123406) /3600) and Excel gives me 919271.1594 as the
answer. The problem is that this is not the right answer!!!
If I do the same calculation on a calculator. The
same formula 1338 / ((576125 - 123406)/3600) gives 10.639 as the answer...
I know that the 9.14 is in the right
range for my answer.
What is it that I do not know?
What do I need to do to get excel to give me the right number.
Note: all of the other Duration values that I am
using in my calculations match the calculator answer. This is the only one that does not!!
Thanks to all for
reading my first post, and a very special thank you to the "WIZARD" that can solve this mystery for me!!!