I have a list of telephone calls exported from another database into CSV then
into Excel (original db only allows export into CSV and cannot be changed).
These are in hours minutes and seconds and could relate to around 500 entries.
I want to calculate the total duration of all calls in hours, minutes &
seconds
A1 = 00:05:03
A2 = 01:18:52
A3 = 00:45:32
TOTAL 02:08:87
I have changed the column to hh:mm:ss and get 00:00:00 as the total. I also
changed the column to text and divided it by 24/60/60 which just gave an
error of VALUE.
Incidentally, if I manually type time in and add it up, I get the correct
time.
Any ideas?