SOLVED

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

Copper Contributor

Why can't I sum this time column? I always get zero. Thanks in advance!

2 Replies
best response confirmed by allyreckerman (Microsoft)
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.

 

 

 

I received them as attachments to an email.

Thanks Riny!
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
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.

 

 

 

View solution in original post