Subtracting Non-Billable Hours

**mycon73** · 12-23-2010, 10:27 AM

Hi Everyone,

I have a table set up like this to highlight attendance codes.

CB 10:00
F 0:00
FH 8:00
H 8:00
IL 8:00
LOA 8:00
PB 8:00
RH 8:00
V 8:00
1/2 V 4:00

Below, I have a task log for Monday through Friday & the weekly total - 55 hrs. in this example.

V 13.0 12.0 12.0 10.0 0.0 0.0 55.0

I am seeking a formula that will subtract the total hours & find non-billable hours, such as vacations (V), 1/2 day vacation (1/2 V) or holidays (H), total this up, then subtract from total hours charged, to get billable hours.

What's a good forumula to use?

Thanks

**BigDat6CC** · 12-23-2010, 10:37 AM

Please attach an example workbook so that we have something on which to work

**mycon73** · 12-23-2010, 10:51 AM

Hi,

I attached an example that was created in Excel 2007.

I am seeking a formul for Cell L58.

Thanks

**mycon73** · 12-23-2010, 04:37 PM

Hi Everyone,

I figured it out! It's a long formula & I'm sure something better could be used but it works!

Here's what I used:

=SUMIF(H55:N55,$E$7,H56:N56)+SUMIF(H55:N55,$E$9,H56:N56)+SUMIF(H55:N55,$E$8,H56:N56)+SUMIF(H55:N55,$E$10,H56:N56)+SUMIF(H55:N55,$E$11,H56:N56)+SUMIF(H55:N55,$E$12,H56:N56)+SUMIF(H55:N55,$E$14,H56:N56)+SUMIF(H55:N55,$E$15,H56:N56)