https://bugs.freedesktop.org/show_bug.cgi?id=88285
raal <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #7 from raal <[email protected]> --- (In reply to bugquestcontri from comment #6) > I tried different format settings but the calculation across midnight is > always wrong in 4.3. > > It is indeed consistent with Excel where ctr+: inserts the actual time > without a date information. In Excel I cannot calculate a time difference > across midnight as well. At least I did not find a solution. As I cannot > calculate across midnight I regard Excel as faulty. > > How can we enter times in Calc (beside manually enter the information > yy/mm/dd hh:mm:ss) and calculate across midnight? > > Can we have a function to enter the "current date & current time" and > allocate a shortcut key to it (eg. ctr+:)? Then we would be consistent with > (poor Excel) and have an additional feature compared to Excel. > > I re-opend the bug because I would like to get an answer to my question. Hello. You can press CTRL+; (this insert DATE) and then on the same cell press CTRL+SHIFT+; (this insert TIME) -> result is date with time. Example: CTRL+; (14.01.2015) & CTRL+SHIFT+; -> result is 14.01.15 13:01 I'll close this as notabug. Maybe this can be enhancement "create shortcut for insert date&time". -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
