Linux Lite Forums

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.



- 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

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]

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.



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.

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/li...mmss-cells for the format for the total hours cell

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

@ Dyslexic...

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

Dave

Many thank.
I make copy before taking it apart.