Hi,

I’m trying to sum hours in excel in a cumulative way, that is, if I add 23:50 and 1:20 the result must be 25:10 and not 1:10. I use the formula SUM and the cell format :mm to do this. The problem is, since aspose put values of datatime type and excel always set a date ahead the time, format :mm sum also the hours related to the date that appears in the cell.

I’ve tried to solve this problem changing the cell format and using the h:mm format but, although this format allows me to set only a time value -without date- in a cell, the sum of times is not cumulative and the result of add, for example, 23:50 and 1:20 is 1:10 and not 25:10 as I want.

Could someone give me a solution for this problem?

<span style=“font-size: 12pt; font-family: “Times New Roman”;” lang=“ES-TRAD”>My version of aspose is the 3.1.1.5, anyway, I’ve downloaded and tested 3.2.0.0 version of Aspose and the problem is not solve yet. I have MS Excel 2003 Professional Edition.

Thanks in advance.

This Topic is created by shakeel.faiz using the Email to Topic plugin.