=TEXT(L9-K9,"h:mm") How can I sum the results to a total value

D

Dave Peterson

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.
 
J

Jacob Skaria

L9-K9

and format the cell to below from Format>Cells>Custom>

[h]:mm

If this post helps click Yes
 
Top