SUM doesn't work with Hours - It always returns 00.00

Discuss the spreadsheet application

SUM doesn't work with Hours - It always returns 00.00

Postby pintus_m » Sun Nov 17, 2019 10:15 am

The SUM function doesn't work with Hours - It always returns 00.00:
BugSUMWithHoursReturn0.png
BugSUMWithHoursReturn0.png (13.98 KiB) Viewed 172 times
Last edited by robleyd on Mon Nov 18, 2019 12:26 am, edited 1 time in total.
Reason: Title Edited
OpenOffice 4.1.7 - Windows 10 Version 1909
pintus_m
 
Posts: 1
Joined: Sun Nov 17, 2019 10:09 am

Re: [BUG] SUM doesn't work with Hours - It always returns 00

Postby F3K Total » Sun Nov 17, 2019 11:12 am

This is no BUG,
seems as if you use text instead of numbers.
SUM_TEXT.png
SUM_TIME.PNG
SUM_TIME.PNG (7.49 KiB) Viewed 165 times
Last edited by F3K Total on Sun Nov 17, 2019 11:17 am, edited 1 time in total.
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 7 OOo, AOO, LOLinux Mint OOo, AOO, LO
F3K Total
Volunteer
 
Posts: 939
Joined: Fri Dec 16, 2011 8:20 pm

Re: [BUG] SUM doesn't work with Hours - It always returns 00

Postby RoryOF » Sun Nov 17, 2019 11:15 am

Time_sum.png
Time_sum.png (17.01 KiB) Viewed 164 times
please upload your sample file so we can see what you are doing wrong.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29870
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: SUM doesn't work with Hours - It always returns 00.00

Postby robleyd » Sun Nov 17, 2019 11:29 am

Welcome to the forum.

This is not a bug - you need to format the cells with the times as time - HH:MM - and the cell in which you have the SUM to display hours greater than 24. Assuming you just want to display hours and minutes separated by a colon, use the format
Code: Select all   Expand viewCollapse view
[HH]:MM
in the cell with the total.

Note that posting an image in this case is not helpful; it shows what you see but gives no idea of how your spreadsheet is set up; thus we can't easily determine the problem without some guessing.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: [BUG] SUM doesn't work with Hours - It always returns 00

Postby RusselB » Sun Nov 17, 2019 4:21 pm

The fact that the times you're trying to sum are left justified supports the presumption that the times are being interpreted as text, rather than numbers, which is what time is.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5667
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 14 guests