i want to subtract c5:n5 from b5 in excel

April 19, 2012 at 13:06:00
Specs: Windows 7
I am trying to compute PTO hours on an ongoing basis. We start a calendar year with 112.50 hours. As employees use them, I want to deduct them from the 112.50. I am using Word 2007.

See More: i want to subtract c5:n5 from b5 in excel

Report •


#1
April 19, 2012 at 16:27:07
I assume you mean that you are using Excel 2007, not Word 2007.

Put this in the cell where you want to see the hours remaining as they are entered into C5:N5...

=B5-SUM(C5:N5)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 20, 2012 at 07:31:43
Thank you so much!!!! That works beautifully.

Report •

Related Solutions


Ask Question