How do i get excel to add a range of times & display as total as .

Gord Dibben

Posts: n/a

Check out the info on dates and times arithmetic on Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#AddingTimes

Gord Dibben Excel MVP

On Tue, 10 May 2005 09:21:13 -0700, "pm_faery"
wrote:

Hi
I'm trying to get excel to add a range of times together and display the
total as the sum of all of these hours. I can enter the times but keep
getting the strangest of totals. Any help please.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to change range for dynamic chart in excel 2000 with button?	ivan	Charts and Charting in Excel	2	April 24th 05 04:10 AM
Stop Excel Rounding Dates	leinad512	Excel Discussion (Misc queries)	1	April 20th 05 04:19 PM
How do I merge in a selected range of cells out of Excel?	powertots4	Excel Discussion (Misc queries)	1	December 28th 04 08:01 PM
Specify a null value in an Excel Database criteria range	Johnnyy2k	Excel Worksheet Functions	2	December 28th 04 04:43 PM
How do I duplicate a sheet 20 times in an excel spreadsheet	danzil	Excel Worksheet Functions	4	December 17th 04 09:23 PM

All times are GMT +1. The time now is 08:53 PM.

Menu

About Us