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

%3CLINGO-SUB%20id%3D%22lingo-sub-2566179%22%20slang%3D%22en-US%22%3EWhy%20can't%20I%20sum%20this%20time%20column%3F%20I%20always%20get%20zero.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2566179%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20can't%20I%20sum%20this%20time%20column%3F%20I%20always%20get%20zero.%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2566179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2566233%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20can't%20I%20sum%20this%20time%20column%3F%20I%20always%20get%20zero.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2566233%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F252411%22%20target%3D%22_blank%22%3E%40topdesk123%3C%2FA%3E%26nbsp%3BThat's%20because%20the%20values%20that%20look%20like%20a%20time%20are%20in%20fact%20texts.%26nbsp%3BChanged%20the%20format%20of%20columns%20H%20and%20I%20to%20%22Time%22%20and%20selected%20each%20cell%20and%20pressed%20enter%2C%26nbsp%3Bbut%20please%20come%20back%20here%20and%20explain%20how%20you%20entered%20or%20imported%20these%20time%20entries%20if%20you%20want%20to%20avoid%20the%20same%20problem%20in%20the%20future.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

2 Replies

@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!