calc dates that are extract via IF formulas Mk2

[slamanager]

Ok I didnt give a clear example etc in my first stab at this issue so im starting up this thread to give a more simplistic view af the issue im scaling

a1: the time that the log file was updated KEYWORD : 16/12/2010 09:09:09 am in the morning
b1: =MID(A1,SEARCH("KEYWORD ",A1,1)+10,23) comes out as a text value
c1: =DATEVALUE(B1) but doesn't show the time only zeros

C1 is what im using to calc with how can i get the time to display ? please

 

[Ganjin]

curious, shouldn't you be using timevalue() instead of datevalue()?

 

[slamanager]

So why isnt there a combined function now i have to combine both, i will have a go and see what i can create.

 

[slamanager]

using the "Value" function all ok now, never used that before this should fix a few things outstanfding on my list