Posts: 182
Threads: 24
Joined: Jul 2014
Reputation:
0
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]](https://db.tt/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
Note to self list to get fixed 1 by 1
Read how to make LL secure.
See what else Linux Lite can do.
I think X kill is cool :)
Posts: 182
Threads: 24
Joined: Jul 2014
Reputation:
0
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]
Note to self list to get fixed 1 by 1
Read how to make LL secure.
See what else Linux Lite can do.
I think X kill is cool :)
Posts: 1,486
Threads: 96
Joined: Mar 2014
Reputation:
0
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]](http://i.imgur.com/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.
Upgrades WIP 2.6 to 2.8 - (6 X 2.6 to 2.8 completed on: 20/02/16 All O.K )
Linux Lite 3.0 Humming on a ASRock N3070 Mobo ~ btrfs RAID 10 Install on 4 Disks :)
Computers Early days:
ZX Spectrum(1982) , HP-150 MS-DOS(1983) , Amstrad CPC464(1984) , BBC Micro B+64(1985) , My First PC HP-Vectra(1987)
Posts: 201
Threads: 21
Joined: Jun 2014
Reputation:
0
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
1) Lenovo T520 i5 LL3.8 8GB ram, fast & stable
2) Medion P4 32bit LL3.8 1GB ram, quite fast & stable
3) eeePC 901 32bit LL3.8 1GB ram, fast & stable
4) eeePC 701 32bit LL3.8 1GB ram, slower & stable but small and light enough to travel with me to New Zealand when visiting family in Blenheim.
(This post was last modified: 08-31-2015, 06:54 PM by
justme2.)
Posts: 182
Threads: 24
Joined: Jul 2014
Reputation:
0
I will read tomorrow with program open
Thanks for time n effort both [emoji41]
Note to self list to get fixed 1 by 1
Read how to make LL secure.
See what else Linux Lite can do.
I think X kill is cool :)
Posts: 1,486
Threads: 96
Joined: Mar 2014
Reputation:
0
@ Dyslexic...
Have pm'd & emailed you...
Best I can do/offer...
Hopefully you can see how it works.
Dave
Upgrades WIP 2.6 to 2.8 - (6 X 2.6 to 2.8 completed on: 20/02/16 All O.K )
Linux Lite 3.0 Humming on a ASRock N3070 Mobo ~ btrfs RAID 10 Install on 4 Disks :)
Computers Early days:
ZX Spectrum(1982) , HP-150 MS-DOS(1983) , Amstrad CPC464(1984) , BBC Micro B+64(1985) , My First PC HP-Vectra(1987)
Posts: 182
Threads: 24
Joined: Jul 2014
Reputation:
0
Many thank.
I make copy before taking it apart.
Note to self list to get fixed 1 by 1
Read how to make LL secure.
See what else Linux Lite can do.
I think X kill is cool :)
