View Single Post
  #2   Report Post  
Old August 20th 07, 01:58 PM posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default Adding hh:mm times in a row as part of a "named" cell



"Joe" wrote:

Hello, I need to add up the times (in h:mm format) of a row of cells. The
sheet I have been given has its base cell (C7) that has been named as Mhours.
This is defined as adding the values in row seven cells from D to AA. The
values for these cells are copied from another spreadsheet where the hours
are displayed in the h:mm format.
My problem is that to calculate I have to drop the : and replace it with a .
instead. The sum of D7:AA7 is not a true h:mm value and, therefore, makes
the final value incorrect.
What formula should be in the definition of the named cell or is there an
alternative formula without naming the cell (C7)? I have tried the
'=TEXT(D7:AA7,"h:mm")' formula, but this does not work; an error seems to
indicate a conflict with the two :'s.