hi 
we are trying with migration from ms office to Libre office and we found problem that if we create spreadsheet in Libre Calc and use sum() formula it will produce wrong value of calculated hours and minutes in ms excel. now this might not be problem of Libre office per se but it makes transition difficult and gives us head ache with migration… first time we noticed last November and it was again brought to my attention …please let me know even if there is any workaround for this issue.
nobody can reproduce the issue without an example.ods which show it!
pleace edit your question and use the ⇑ -upload-button in the middle of the tool-bar
1 Like
Imho Excel and Calc use the same internal format for date/time: A serial number of days since (nearly) the beginning if the 20th century as date and a fraction of 24 hours for time. So there should be no problem.
.
If you find problems, check at first if you are mixing text-strings, wich look like dates for you, but may be treated differently in Excel and Calc.
.
If your headache persists, consider to give us something to test.
We don’t need your complete files, you may remove everything not related to your “sum of dates”.
.
How do you test?
Same .xlsx/ods-file or separate files? For separate files, check, if the values are shown rounded and if all values are really identical.
1 Like
Good morning 
thank you for your replies… we will try to produce repeatable steps to find why/when this happens
hi… with first step i see we have a problem with formating where time is calculated on base 24… i want to format h:mm to sum the duration of time…if anyone can help me with proper formating of the cell…so that it doesnt show 1:30. I want to show 25:30 in the cell.
regards
Use [HH] for the hours-part
where do i set this [HH]?
Compare this ( and remember(?) you can actually edit the format-code highlighted in red) Maybe click directly on “[image descripion]” below:
thank you i just noticed that formating field at the bottom. applied and it works correctly.
1 Like