Ask Your Question
0

LO Time Calculation Issue [closed]

asked 2014-02-18 20:04:16 +0100

deafpeace gravatar image

updated 2015-09-12 14:46:50 +0100

Alex Kemp gravatar image

I currently have LO Version: 4.1.2.3 and am running it on Windows XP Professional 5.1.

I am trying to make a database to add my time in and on. I need to figure out what is wrong with my formula.

I have entered the following in cells a2:b7 with the format of time hh:mm:
07:55 AM 02:55 PM 07:55 AM 10:30 AM 02:15 PM 02:55 PM 07:55 AM 02:55 PM 07:55 AM 02:55 PM 07:55 AM 12:05 PM

I have entered the formula "=SUM(B2-A2)" in cells c2:c7 also in the format of time hh:mm. Here are the calculations, and they are correct, that have displayed in the cells.
07:00 02:35 00:40 07:00 07:00 04:10.

In cell c8 I have the formula "=SUM(C2:C7)*24" to allow for the whole number of hours and minutes. I have also formatted the cell to be a number, decimal to allow for it to show hours and minutes correctly.

However, it comes up with the answer 28.42 and NOT 28.25.

I can't figure out where the error is. Any suggestions?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:20:30.403073

Comments

28.42 hours expressed/formatted as NUMBER (Base 10) IS app. 28 hours 25 minutes (0.42 * 60 = 25.2)

Edward gravatar imageEdward ( 2014-02-19 22:29:12 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-02-18 21:34:43 +0100

m.a.riosv gravatar image

Without multiply by 24 you can achieve the total hours with a format like: [HH]:MM you can find it in the Category Time in the Format cells - Numbers.

edit flag offensive delete link more

Comments

THANK YOU!

However, I only found [HH]:MM:SS.00 listed in the Format Cells, Numbers, Time section. Is there a way to customize it for just [HH]:MM?

Do you know why the "*24" did not work when minutes were entered? I have another section with the same formula that worked but there were no minute entries.

deafpeace gravatar imagedeafpeace ( 2014-02-19 14:43:21 +0100 )edit

Delete the rest of the format. You can edit the format as you like.

And If you multiply by 24, the integer part are hours, but decimal part are not minutes then in the spreadsheet format.

m.a.riosv gravatar imagem.a.riosv ( 2014-02-19 22:41:28 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2014-02-18 20:04:16 +0100

Seen: 132 times

Last updated: Feb 18 '14