View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve M Steve M is offline
external usenet poster
 
Posts: 17
Default Problem with Time Addition

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