Jul 20 2021 07:48 AM
Why can't I sum this time column? I always get zero. Thanks in advance!
Jul 20 2021 07:57 AM
Solution@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.
Jul 20 2021 01:43 PM
Jul 20 2021 07:57 AM
Solution@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.