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 184.108.40.206, anyway, I’ve downloaded and tested 220.127.116.11 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.