When i try to add a date field with time field, aspose is not giving me the right result
The type for the date cell (A1) is Datetime and for the time cell (B1) is double.The Result cell is of type DateTime.
When i add 01/01/2012 1:00 with 00:30, it returns 01/01/2012 13:00 instead of 01/01/2012 1:30 . When i checked the excel generated by Aspose, instead of treating time as 00:30, it is treating time as 12:00:00.
Please help me to resolve this issue.