Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

sum of time

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Guy Cohen - 15 Nov 2006 11:44 GMT
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
Bob Phillips - 15 Nov 2006 11:47 GMT
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
Guy Cohen - 15 Nov 2006 12:14 GMT
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
Bob Phillips - 15 Nov 2006 12:21 GMT
Well I did, and it did, it really was that simple! I get 28:28.

And your original example works too.

Signature

HTH

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
Guy Cohen - 15 Nov 2006 12:41 GMT
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
Bob Phillips - 15 Nov 2006 13:37 GMT
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

Rate this thread:






 
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.