I can not say enough about HOW STUPID people are in excel.
I wish this piece of crap had never been invented.
I have spent 3 days converting text junk into usable data.

I am on the last thing a time value.
Of course I have unk, not done, not available and the VERY GOOD
if its pink or red its nite time AHHHHHHHHHHHHHHHHHHH

anyway I am down to this
First time I tried this it ran and all my output data was #ERROR
so I ran it again it says invalid syntax

I thought this was the )
on the end of each line I have Right([time],2)),
I tried moving them to the end
Right([time],2), on each line and then )) at the end but that stops on
=4, TimeSerial <<<< and says unknown

Does any one have any idea how to get this to work? I am stumped


switch( ucase([time])="UNK","",

Len([time])=4,TimeSerial(Left([time],2),Right([time],2)),

Len([time])=3,TimeSerial(Left([time],1),Right([time],2)),

Len([time])=2,TimeSerial(Right([time],2),"00")

)