Linux Lite Forums
Sorry very basic libreoffice time calculations hours - Printable Version

+- Linux Lite Forums (https://www.linuxliteos.com/forums)
+-- Forum: General (https://www.linuxliteos.com/forums/forumdisplay.php?fid=4)
+--- Forum: Off Topic (https://www.linuxliteos.com/forums/forumdisplay.php?fid=15)
+--- Thread: Sorry very basic libreoffice time calculations hours (/showthread.php?tid=2140)

Sorry very basic libreoffice time calculations hours - DLX - 08-31-2015

I have looked at videos, bit don't get right out come  :-[ My maths just as great and my English.
using libreoffice spreadsheet

what would like is to add up hours from on time to end time (should be easy)

I put start time in column B Cell 2 = B2 and end time in column C Cell 2

10:00 B2 15:00 C2 in column D Cell 2 =C2-B2 then hit enter done show me hours from start to end.
once I get the hours I would like a total then up to.

I also clicked in cell format cell to numbers and get error Err:552[table][tr][td][/td][/tr][/table]Thanks
Sorry did say very basic.

[Image: HwtzhUnB]

- 15:15 why -
I know i'm doing this the slow way =Cx - Bx how would add left column B to C column please.
instead of

=C2-B2
=C3-B3
=C3-B4
=C5-B5
so on


thanks  :-[




Thanks




Re: Sorry very basic libreoffice time calculations hours - DLX - 08-31-2015

Kind got it working but not over night

21:00 - 07:30
Quote:  [table]  [tr] [td]
21.00
[/td] [td]
04:30
[/td] [td]
-20.81
[/td] [/tr] [/table]

wrong  :-\
  [table]  [tr] [td][/td] [td][/td] [td][/td] [/tr] [/table]


Re: Sorry very basic libreoffice time calculations hours - Wirezfree - 08-31-2015

Hi,

The issue is the "past midnight" calc.
I dug out an old Excel sheet, and knocked this up, it still works in Libre Calc.

[Image: La8kRik.png]

The field that does the difference needs to do a check,
I think I got this of the web/colleague..??

In the sum/difference cell you need to have:

Example:
Cell E2 contains =D2-C2+(C2>D2)

I can send you this if you PM me an emaill addy.

Re: Sorry very basic libreoffice time calculations hours - justme2 - 08-31-2015

I've just played with Libre  Calc and it seems all you need to do is set the cell format to time as hh:mm then subtract start time from end and sum the total time cells. Calc appears to take care of passing midnight events.

See http://superuser.com/questions/387106/libreoffice-calc-how-to-get-total-for-hhmmss-cells for the format for the total hours cell

Re: Sorry very basic libreoffice time calculations hours - DLX - 08-31-2015

I will read tomorrow with program open
Thanks for time n effort both 


Re: Sorry very basic libreoffice time calculations hours - Wirezfree - 09-03-2015

@ Dyslexic...

Have pm'd & emailed you...
Best I can do/offer...
Hopefully you can see how it works.

Dave

Re: Sorry very basic libreoffice time calculations hours - DLX - 09-03-2015

Many thank.
I make copy before taking it apart.