08-31-2015, 05:20 PM
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.
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)
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)