mx amber alex on Nostr: jfc I've been trying to get LibreOffice Calc to get me the difference between two ...
jfc I've been trying to get LibreOffice Calc to get me the difference between two DateTimes within one formula for half an hour.
What I want is something along the lines of =(Sep 11, 2024 21:05 minus Sep 9, 2024, 11:00)*24. For reasons, putting both time stamps into separate cells (it works then) is undesireable.
I've tried everything. Datedif only returns whole days. =DATE(...)-DATE(...) has no room to enter numbers. I fucking hate it.
#LibreOffice #Calc
What I want is something along the lines of =(Sep 11, 2024 21:05 minus Sep 9, 2024, 11:00)*24. For reasons, putting both time stamps into separate cells (it works then) is undesireable.
I've tried everything. Datedif only returns whole days. =DATE(...)-DATE(...) has no room to enter numbers. I fucking hate it.
#LibreOffice #Calc