Google Sheets note summing Time Duration - possibly due to a return string problem?
I'm making a time tracker for my work-from-home and I almost have it where I want it, except that the Expected Time column will not SUM (fig. A). I'm auto-filling the correct expected time based on text from the Type column , and to get the Expected Time column to show as the Time Duration format correctly, I'm exporting the time as a string "3:00:00" or "6:00:00" (fig B). All I need is for the Expected Time total to sum - I'm able to use those cells as values in formulas for the Difference column (fig C), so I'm not sure why the SUM function in cell E6 isn't working. Any ideas to either return the Expected Time correctly without using the "", or to get the column to SUM would be appreciated!
fig. A)
fig B)
fig C)
Posted Jan 4, 2025, 7:31 PM UTC