I have no clue what that is supposed to be.

All I want is for the 24:00 and up to be read as it should. I don't want
25:03 to be read as 1:03 in the cell or in the value box. I have a table set
aside to be compared with the times in the cell/value box and I need it to be
the same as what is inputted. Also, I don't want to go through the hassle of
putting in 0:25:03.

Also, 25:03 is a generic number. I'm merely using it as an example. Nothing
is special about 25:03.

"Peo Sjoblom" wrote:

This formula is more robust, also entered with ctrl + shift & enter

=IF(COLUMNS($B1:B1)<=COUNTIF(Sheet2!$C$2:$C$2934,$ C$2),INDEX(Sheet2!$D$1:$D$2934,SMALL(IF(Sheet2!$C$ 2:$C$2934=$C$2,ROW(Sheet2!$C$2:$C$2934)-COLUMN(Sheet2!$C$2)+3),COLUMNS($B1:B1))),"")


test them side by side

then select column A in the same sheet that holds the formulas and insert a
new column, every time you insert a new column the first formula will change
the result and eventually there will just be blank cells returned while the
above formula still returns the correct result, also it has less function
calls so it should be faster


--


Regards,


Peo Sjoblom


"Darryl_Neeley" wrote in message
...
Is there not another way to format it? I want it just to leave whatever is
in
there alone, and read it like it is. The way it is reading it is throwing
off
my calculations. It reads different above 24:00. It should read the same
throughout.

"T. Valko" wrote:

Format the cell as mm:ss

Then, when you enter the time you need to enter it as 0:25:03 but it will
display as 25:03.

--
Biff
Microsoft Excel MVP


"Darryl_Neeley" wrote in message
...
I need to know how to fix this little problem. I'm using the time as an
accumulated time, not as in a definitive time. As in 25 minutes, 3
seconds.

Thanks for the help. I'm sure it's probably a simple fix.