Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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?