Random SUM calculation issue in Pivot Table

[mikenz1983]

Hey Guys

i have a pivot table that is showing me the following data as an example
the duration column is formatted to sum and the formatting is Time at [hh]:mm:ss

Date	Sum Connected Time
3-Oct	18:56:25
4-Oct	12:01:28
5-Oct	14:58:16
6-Oct	12:25:01
9-Oct	14:24:48
10-Oct	15:09:34
11-Oct	13:43:58
12-Oct	00:00:00
13-Oct	00:00:00
16-Oct	00:00:00
17-Oct	00:00:00
18-Oct	00:00:00
19-Oct	00:00:00
20-Oct	00:00:00

From the 12 Oct onwards ( this is from 2023 to 2024 ) i am showing no calculation at all, however when i double click on the table i see the data is present, i am unsure as to why, the below is what is showing for the 12/10

Calling TIME	Channel	Direction	Call Result	Connected Time
12/10/2023 12:29	Prod_Rates Queue	Inbound		00:09:55
12/10/2023 9:43	Prod_Rates Queue	Inbound		00:05:45
12/10/2023 13:06	Prod_Rates Queue	Inbound		00:08:18
12/10/2023 8:01	Prod_Rates Queue	Inbound		00:02:42
12/10/2023 8:05	Prod_Rates Queue	Inbound		00:04:10
12/10/2023 14:12	Prod_Rates Queue	Inbound		00:01:48
12/10/2023 11:55	Prod_Rates Queue	Inbound		00:01:21
12/10/2023 13:11	Prod_Rates Queue	Inbound		00:06:11
12/10/2023 11:17	Prod_Rates Queue	Inbound		00:05:27
12/10/2023 12:11	Prod_Rates Queue	Inbound		00:01:01
12/10/2023 10:04	Prod_Rates Queue	Inbound		00:06:20
12/10/2023 11:24	Prod_Rates Queue	Inbound		00:06:32
12/10/2023 11:01	Prod_Rates Queue	Inbound		00:10:47

the only thing i am seeing is the formula field for anything Before Oct displays duration like this

12:09:13 am

where after it is this

00:04:31

i am not to sure how to resolve this if this is the issue, as i have changed the cell formatting to be the same for all

 

[arthurbr]

Please check the following : remove any manual alignment from col " Connected Time". If the data is left aligned the time is text ( whatever formatting applied).
If so, select the column, Data- Text to columns - Finish. If cell contents are now right aligned, you have real time not text. If this does not work there are some other tricks possible