• ## Andrew

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

#### 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

#### Need help with total monthly hours

If I take out the formula in rows 11 and rows 25 and change the format to h:mm:ss everything works fine but I have to manually calculate all the times...

dcope7 Today, 03:59 PM