 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006sum of time
Hi all I have a column with HH:nn data I want excel to sum the values - is it possible ? e.g.: 12:40 20:10 ------------- 32:50 TIA Guy Just sum as usual and format the results cell as [h]:mm -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > Hi all > I have a column with HH:nn data [quoted text clipped - 7 lines] > TIA > Guy Dear Bob Thanks for the reply I would not post the question if it was that simple. Put 12:33 in A1, and 15:55 in A2 Try to set A3 to be the sum.... Guy > Just sum as usual and format the results cell as [h]:mm > [quoted text clipped - 17 lines] >> TIA >> Guy Well I did, and it did, it really was that simple! I get 28:28. And your original example works too.  SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Dear Bob > Thanks for the reply [quoted text clipped - 26 lines] > >> TIA > >> Guy can you please post your excel file here? pleaseeeeeeeee? G > Well I did, and it did, it really was that simple! I get 28:28. > [quoted text clipped - 30 lines] >> >> TIA >> >> Guy I have posted it to http://cjoint.com/?lpoKS6B5Zu -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) > can you please post your excel file here? > pleaseeeeeeeee? [quoted text clipped - 41 lines] > >> >> TIA > >> >> Guy
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.