Forum Discussion
Solved
Nested IF formula column’s SUM problem
Hi there , I have a column with Nested IF formula and I need to sum of column and sum is showing 00:00 with SUM formula. Can anyone solve this error
You use "10:00" in your formula. That is text. And SUM() ignores text.
Either convert with TIMEVALUE() or double-negative or use TIME() or 10/24.
There is also formula to get answer of time spend on work . Formula is =MOD(D251-C251,1). IN ‘G’ column have a nested formula IF that’s show in pic , but I need a sum of G column which is last column on right
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.