View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default =TEXT(L9-K9,"h:mm") How can I sum the results to a total value

L9-K9

and format the cell to below from FormatCellsCustom

[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"be013fc" wrote:

Setting up a time sheet