You are Here:
Linux Lite 6.6 FINAL Released - Support for 22 Languages Added - See Release Announcement Section



Sorry very basic libreoffice time calculations hours

Author (Read 7825 times)

0 Members and 1 Guest are viewing this topic.

Re: Sorry very basic libreoffice time calculations hours
« Reply #7 on: September 03, 2015, 07:07:09 AM »
 

DLX

  • PayPal Supporter
  • Forum Regular
  • *****
  • 182
    Posts
  • Reputation: 11
  • Knows sod all
    • View Profile

  • MEMORY: 16Gb
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 :)
 

Re: Sorry very basic libreoffice time calculations hours
« Reply #6 on: September 03, 2015, 06:58:45 AM »
 

Wirezfree

  • PayPal Supporter
  • Platinum Level Poster
  • *****
  • 1484
    Posts
  • Reputation: 405
  • Linux Lite "Advocate"
    • View Profile

  • CPU: i7-4790S

  • MEMORY: 16Gb

  • VIDEO CARD: Intel HD4600 (Integrated)
@ 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)
 

Re: Sorry very basic libreoffice time calculations hours
« Reply #5 on: August 31, 2015, 03:26:02 PM »
 

DLX

  • PayPal Supporter
  • Forum Regular
  • *****
  • 182
    Posts
  • Reputation: 11
  • Knows sod all
    • View Profile

  • MEMORY: 16Gb
I will read tomorrow with program open
Thanks for time n effort both 
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 :)
 

Re: Sorry very basic libreoffice time calculations hours
« Reply #4 on: August 31, 2015, 02:44:37 PM »
 

justme2

  • PayPal Supporter
  • Forum Regular
  • *****
  • 201
    Posts
  • Reputation: 25
  • Linux Lite Member
    • View Profile

  • CPU: Intel i5 vPro

  • MEMORY: 8Gb

  • VIDEO CARD: Intel
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
« Last Edit: August 31, 2015, 02:54:43 PM by justme2 »
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.
 

Re: Sorry very basic libreoffice time calculations hours
« Reply #3 on: August 31, 2015, 01:20:00 PM »
 

Wirezfree

  • PayPal Supporter
  • Platinum Level Poster
  • *****
  • 1484
    Posts
  • Reputation: 405
  • Linux Lite "Advocate"
    • View Profile

  • CPU: i7-4790S

  • MEMORY: 16Gb

  • VIDEO CARD: Intel HD4600 (Integrated)
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.
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)
 

Re: Sorry very basic libreoffice time calculations hours
« Reply #2 on: August 31, 2015, 12:05:40 PM »
 

DLX

  • PayPal Supporter
  • Forum Regular
  • *****
  • 182
    Posts
  • Reputation: 11
  • Knows sod all
    • View Profile

  • MEMORY: 16Gb
Kind got it working but not over night

21:00 - 07:30
Quote
 
21.00
04:30
-20.81


wrong  :-\
 
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 :)
 

Sorry very basic libreoffice time calculations hours
« Reply #1 on: August 31, 2015, 11:07:10 AM »
 

DLX

  • PayPal Supporter
  • Forum Regular
  • *****
  • 182
    Posts
  • Reputation: 11
  • Knows sod all
    • View Profile

  • MEMORY: 16Gb
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
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


« Last Edit: August 31, 2015, 11:46:51 AM by Dyslexic1 »
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 :)
 

 

-->
X Close Ad

Linux Lite 6.6 FINAL Released - Support for 22 Languages Added - See Release Announcement Section