View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Sum work hours to hours & nearest 10th of an hour

Hi Howard,

Am Thu, 17 Jul 2014 02:45:01 -0700 (PDT) schrieb L. Howard:

The one you offer up returns #VALUE error.

Could that be because it refers to columns with dates in then?


no, the formula is tested and it works.
I guess your data has wrong formats.
Can you send me the file?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional