Posts: n/a

histogram for time values

hi,

I have a whole column of time values -- 9:30, 11:00, 12:30.... etc.

I want to analysis this data, finding the max time( latest time), min time,
mode time, and
create a histogram out of it.

excel will tell me that time is a non-numeric data and refuses to create the
histogram.

any way around this?

thnks.

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
Using Match function with duplicate values in an array	Richard	Excel Worksheet Functions	3	April 22nd 23 07:45 PM
Combine FREQUENCY and SUM of Associated Values	MichaelC	Excel Worksheet Functions	3	July 3rd 05 01:54 AM
Return Consecutive Values - Pairs	Sam via OfficeKB.com	Excel Worksheet Functions	6	July 2nd 05 04:43 PM
Charting cumulative values in histogram ?	TonyB	Charts and Charting in Excel	3	February 22nd 05 04:23 PM
Second serie doesn't use X-as values	JackRnl	Charts and Charting in Excel	1	January 20th 05 01:04 AM

All times are GMT +1. The time now is 09:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us