As per the getting started guide and just in case the OS being used is Windows 10, LibreOffice version 18.104.22.168 64-bit and file format is ods.
I can’t for the life of me figure this out after reading countless related questions here.
So my problem is as follows:
I would like to subtract a field in the format of “HH:MM DD/MM” say, “13:04 26/07” subtracted by 32 hours so on the field below (or wherever) it’d look something like “05:04 25/07”.
I’ve been trying with -TIMEVALUEs and -DATEVALUEs but my knowledge of all the possible functions are really limited since reading all the other posts was my introduction to any of these time and date functions and I’m having a real tough time comprehending them so I don’t know if I’m headed entirely in the wrong direction.
So far I only managed to subtract from individual fields of “HH:MM” and “DD/MM”. I imagine that trying to play with the bizarre number of 32 hours is not doing me any favors when I want to cram both time and a date in one box.