I tried to show a chart where the values are the sum of times. It looks ok in the spreadsheet with for example 19 hours and 25 hours but in the chart, the 19 is ok but the 25 is shown as 1. The format in the chart is "time on a day" not the sum of time.

Anyone who knows how it can be correct?

  • pls share a copy of your sheet
    – user0
    Commented Mar 25, 2019 at 21:05

1 Answer 1


I found out myself that if I changed the format of the time-column to "[h]:mm;;" then the diagram was correct.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.