• ## jcabral

There is no available content written by jcabral
• ### Recent Forum Posts

#### Need help with total monthly hours

I took the 12 out and if you key in 0:30 it row 12 it still subtracts from row 16 which is what it is supposed to do. I've tried every format I could...

dcope7 Today, 07:05 PM

#### Need help with total monthly hours

It does not! it adds the value 12 and doesn't even look at row 12! In this context it adds 12 days (=288 hours). Barmy.
Until you get formulae right...

p45cal Today, 06:02 PM

#### Need help with total monthly hours

Ok row 16 calculates rows 11 and 15, plus it subtracts row 12 and yes I know I have it adding but if you actually add 0:30 in row 12 it will subtract...

dcope7 Today, 05:23 PM

#### Need help with total monthly hours

I'm talking about row 16, NOT ROW 12!
The 12 is a hard-coded 12 in the formula, and it adds (not subtracts) 12. The formula in cell D16 (yes, the...

p45cal Today, 05:10 PM

#### Need help with total monthly hours

It subtracts any non-billable times...

dcope7 Today, 03:59 PM