View Single Post
 
Old 01-17-2020, 01:08 AM
otuatail otuatail is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Jun 2012
Posts: 246
otuatail is on a distinguished road
Default add up HH:MM:SS (Office 2007)

How to add up a column of HH:MM:SS

I am looking at my talk talk phone bill. I downloaded it as a CSV, re=adjusted the column widths and saved it as an xlsx. The sheet was set up as custom for the times of calls. I tried to convert them to time. I ten hi-lighted all the calls down to below the last and clicked on sum. It doesn't work. I am attaching it for someone to tell me where I am going wrong.

Thanks
Attached Files
File Type: xlsx MyBill.xlsx (11.7 KB, 8 views)
File Type: xlsx MyBill_Dosnt_add_up.xlsx (12.1 KB, 8 views)
Reply With Quote