D Dave Peterson Jul 18, 2009 #2 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.
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 Jul 18, 2009 #4 L9-K9 and format the cell to below from Format>Cells>Custom> [h]:mm If this post helps click Yes
S Shane Devenshire Jul 18, 2009 #5 Hi, You might also what to look at some free Excel timesheet templates at: http://office.microsoft.com/en-us/templates/CT101172771033.aspx
Hi, You might also what to look at some free Excel timesheet templates at: http://office.microsoft.com/en-us/templates/CT101172771033.aspx
