Thread: =TEXT(L9-K9,"h:mm") How can I sum the results to a total value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default =TEXT(L9-K9,"h:mm") How can I sum the results to a total value
Don't use the =text() function.

Just do the subtraction and format the cell: h:mm

ps. It's better to write your question in the body of the message--not just in
the subject.

be013fc wrote:

Setting up a time sheet

--

Dave Peterson
Reply With QuoteReply With Quote