Forum Discussion

topdesk123's avatar
topdesk123
Copper Contributor
Jul 20, 2021
Solved

Why can't I sum this time column? I always get zero.

Why can't I sum this time column? I always get zero. Thanks in advance!
  • Riny_van_Eekelen's avatar
    Jul 20, 2021

    topdesk123 That's because the values that look like a time are in fact texts. Changed the format of columns H and I to "Time" and selected each cell and pressed enter, but please come back here and explain how you entered or imported these time entries if you want to avoid the same problem in the future.