hy,
what do you mean with this part:
"After inputing 13:30m 1:30PM "
13:30 is treated as time value, but if you enter 13:30m excel belive you
entered text and formula returns error #VALUE!

sasa



"Steve M" wrote in message
...
I have times imported into excel from my handheld. The times are put into
the handheld as 13:30 for 1:30PM. After inputing 13:30m 1:30PM
automatically shows up in the appropriate cell. After synchronizing to a
spreadsheet on my desktop I can't subtract one time from another. I get the
result #VALUE!. I have tried changing the formatting of the appropriate
cell, butthis does not help.


TIA