Posted to microsoft.public.excel.misc

external usenet poster

Posts: 132

Max value formula doesn't work

Hi

I have a colum of 514 rows with hours information (15:00, 0:30, etc). I
want to get the maximun number of hours within this range. I have used the
formula =max(a1:a514) but the outcome is 0:00. I have done this calculation
before with hours and it has worked. The ranges have been smaller, though.

Could anyone help me to figure out how to do it or why it is not working?

Thanks,
Orquidea

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
Formula will not work	Indymanny	Excel Discussion (Misc queries)	6	May 15th 07 10:50 PM
Why does this formula not work?	DaveMoore	Excel Worksheet Functions	4	February 27th 07 10:02 AM
Cant quite get this formula to work:	CarolineHedges	Excel Worksheet Functions	2	July 31st 06 10:58 AM
A search for $ in a formula use to work now it does not work	JuneJuly	Excel Discussion (Misc queries)	2	November 30th 05 10:13 PM
How does this formula work	KB	Excel Worksheet Functions	3	March 25th 05 02:52 PM

All times are GMT +1. The time now is 02:28 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us