Jun 05 2022 01:28 PM
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
Jun 05 2022 01:50 PM
The values in column F are left-aligned. That suggests they might be text values.
Try the following:
Does that make a difference?
Jun 05 2022 02:13 PM
Jun 05 2022 02:47 PM
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.
Jun 05 2022 03:49 PM
SolutionYou 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.
Jun 06 2022 02:57 AM
@Detlef Lewin yes, this has been worked , but SUM still not working if I select them sum shows on bottom .
Jun 06 2022 03:37 AM
Jun 05 2022 03:49 PM
SolutionYou 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.