sum of hours that exceed 24 disappear

A weekly worksheet of around 8 hours per day should sum up to 40 hours. However, calculating sum of cells with values 8:00, 8:00, 8:00, 8:00 8:00 = 16:00, ie I worked only 16 hours that week. All relevant cells were formatted as “time” before entering any values.
Is there a way in which Libre Office Calc do this calculation and show the correct result?


format your sum cell as [HH]:MM instead of HH:MM. This allows hours to be greater than 24, while HH:MM shows modulo 24.

So the [] time formats are for time intervals, while “usual” time formats without the [] are for time of the day.

If I add 5 + 13:30 + 3:30 = 22 => OK. If I add 6.30 on it I obtain 4:30 without []-format and 28:30 with []-format => OK too, but if I add 9 at the end I obtain 13:30 for both cases and I think this is for []-formatting not OK

Without a sample file, it’s unclear what you actually add. Plain number 9 (which is 9 days = 9*24 hours)? or 9:00? or some string? or…?

@joewil - I’m confused about your statements

image description