View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Import Qucikbooks Problem - formatting

Excel is interpreting the 6000 as minutes and the 6105 as seconds, then
converting the seconds to minutes (6105 / 60 = 101.75) then adding the
minutes to arrive at 6101.75.

In the formula bar above the column headers, does Excel show 6000:6105,
or the converted 6101.75?