I could download my telephone bill online.
When I view the bill online The Duration of Call column which is listed in
minutes appears as (for example)
5:00 ..............(for 5 minutes)
16:00.............(for 16 minutes)
21:00.............(for 21 minutes)
29:00.............(for 29 minutes)
32:00.............(for 32 minutes)
When I copy or download the bill this column appears as (Same example)
5:00................(for 5 minutes)
16:00.............(for 16 minutes)
29:00:00.............(for 29 minutes)
32:00:00.............(for 32 minutes)
I would like to be able to do a total for the number of minutes for over 500
calls listed in my bill. Do I need to change the format of the cells. When
I look in the formulas bar, the 29:00:00 (29 minutes), I see 01-01-1900
5:00:00 AM
Thanks for help
Bookmarks