i have a formula which calculates my working hours for each day " =C9+(B9>C9)-B9 " ... when i try to sum all the hours resulted from that formula it gives me some other numbers ...
can anyone please help ? is there a way to change the result of that formula into text so i can sum it or is there a way to calculate it directly ?
Hello my friend , i came up with a whole new formulas check it out
in picture number 1 we calculate the time and format it in h:mm ... then in pic number 2 we convert the hours into minutes then in pic number 3 we convert it back into hours with formatting cells with numbers and 0 decimals ...
then in pic number 4 u just select the cells u want to sum and u can see the answer down in the bottom ... or u can simply add the =sum formula
and voila :D
im sorry maybe i explained wrong ...
https://www63.zippyshare.com/v/13824067/file.html this is the image of what is actually happening as u can see im tryin to sum the cells D9 to D13 but the answer is 16 which is wrong
the the formula in D9 is =C9+(B9>C9)-B9