Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-17-2020, 01:08 AM
otuatail otuatail is offline add up HH:MM:SS (Office 2007) Windows 7 64bit add up HH:MM:SS (Office 2007) Office 2007
Competent Performer
add up HH:MM:SS (Office 2007)
 
Join Date: Jun 2012
Posts: 245
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, 10 views)
File Type: xlsx MyBill_Dosnt_add_up.xlsx (12.1 KB, 10 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot get latest Office Updates for Office 2007, Using Windows 7 Home Premium DLD1100 Office 1 12-01-2022 12:12 AM
Run-time error in VB.NET program that worked under Office XP but quit when upgraded to Office 2007 Dick_in_Dallas Misc 0 03-14-2015 07:07 PM
Proper Procedure for updating Office 2000 to Office 2007 Professional stevetag Office 5 08-03-2012 02:47 AM
Using Korean language dictionary from Office 2007 on Office 2011 doable? kylera Office 0 07-10-2012 02:12 AM
Using Office Premium 2007 Trial with Already Installed Office Home and Student 2007 SME Office 1 10-07-2009 06:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft