How can I add times, i.e., 1:45:30 + 2:10:20?
 

How can I add the times of individual phone calls to get the total time spent
calling from a particular phone number? The phone call record has been
placed on an Excel spreadsheet in the hour:minute:second format and sorted by
phone number with associated length of call. I've formatted the column for
times. In the next column, cell G22, I've placed the formula =SUM(F4:F22);
the formula returns zero.

Why won't the formula total the time?

Thanks.

How can I add times, i.e., 1:45:30 + 2:10:20?
 

Have you formatted the results cell as [h]:mm:ss

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"wahjazz" wrote in message
...
How can I add the times of individual phone calls to get the total time
spent
calling from a particular phone number? The phone call record has been
placed on an Excel spreadsheet in the hour:minute:second format and sorted
by
phone number with associated length of call. I've formatted the column
for
times. In the next column, cell G22, I've placed the formula
=SUM(F4:F22);
the formula returns zero.

Why won't the formula total the time?

Thanks.

How can I add times, i.e., 1:45:30 + 2:10:20?
 

It will. If your total time is greater than 24 hours, you need the format
[h]:mm:ss to display them. Otherwise, Excel converts anything greater than 24
hours to days.

--
Regards,
Fred


"wahjazz" wrote in message
...
How can I add the times of individual phone calls to get the total time spent
calling from a particular phone number? The phone call record has been
placed on an Excel spreadsheet in the hour:minute:second format and sorted by
phone number with associated length of call. I've formatted the column for
times. In the next column, cell G22, I've placed the formula =SUM(F4:F22);
the formula returns zero.

Why won't the formula total the time?

Thanks.