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...
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...
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...
Knowledge Base Articles By Category
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.
p45cal Today, 06:02 PMUntil you get formulae right...