LO Time Calculation Issue

I currently have LO Version: and am running it on Windows XP Professional 5.1.

I am trying to make a database to add my time in and on. I need to figure out what is wrong with my formula.

I have entered the following in cells a2:b7 with the format of time hh:mm:
07:55 AM 02:55 PM
07:55 AM 10:30 AM
02:15 PM 02:55 PM
07:55 AM 02:55 PM
07:55 AM 02:55 PM
07:55 AM 12:05 PM

I have entered the formula “=SUM(B2-A2)” in cells c2:c7 also in the format of time hh:mm. Here are the calculations, and they are correct, that have displayed in the cells.

In cell c8 I have the formula “=SUM(C2:C7)*24” to allow for the whole number of hours and minutes. I have also formatted the cell to be a number, decimal to allow for it to show hours and minutes correctly.

However, it comes up with the answer 28.42 and NOT 28.25.

I can’t figure out where the error is. Any suggestions?

28.42 hours expressed/formatted as NUMBER (Base 10) IS app. 28 hours 25 minutes (0.42 * 60 = 25.2)

Without multiply by 24 you can achieve the total hours with a format like: [HH]:MM
you can find it in the Category Time in the Format cells - Numbers.


However, I only found [HH]:MM:SS.00 listed in the Format Cells, Numbers, Time section. Is there a way to customize it for just [HH]:MM?

Do you know why the “*24” did not work when minutes were entered? I have another section with the same formula that worked but there were no minute entries.

Delete the rest of the format. You can edit the format as you like.

And If you multiply by 24, the integer part are hours, but decimal part are not minutes then in the spreadsheet format.