Ask Your Question
0

sum of hours that exceed 24 disappear

asked 2019-09-12 17:55:40 +0200

BC gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2019-09-12 18:07:49 +0200

Opaque gravatar image

updated 2019-09-12 18:14:17 +0200

Hello

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.

edit flag offensive delete link more

Comments

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

Mike Kaganski gravatar imageMike Kaganski ( 2019-09-13 09:42:26 +0200 )edit

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

joewil gravatar imagejoewil ( 2019-09-15 18:25:32 +0200 )edit

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...?

Mike Kaganski gravatar imageMike Kaganski ( 2019-09-15 19:27:04 +0200 )edit

@joewil - I'm confused about your statements

image description

Opaque gravatar imageOpaque ( 2019-09-15 19:53:28 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2019-09-12 17:55:40 +0200

Seen: 26 times

Last updated: Sep 12