formula help

excelledsoftware · #1 03-24-2012, 11:21 AM

Quote:

Originally Posted by Catalin.B

The bormula will be based on SUMPRODUCT, but you must upload a sample data to see the format used, especially for that military time, is it entered as text, or the column is formatted as date "hhmm" ?

My apologies. The format is in just a custom number with 0000 in order to show the 0 before. The number is calculated in a different table with vertical lookup. The number appears exactly as written and formula isnumber for the military time format = true.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM
help with a look up or if formula	beb1227	Excel	3	12-31-2011 01:08 PM
help with formula?	doczilla	Excel	2	09-25-2011 04:14 PM
Help with formula please.	AndrewSE	Excel	3	04-05-2011 08:50 PM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM