Thanks great info, may I suggest you use a date where the Month & Day are easily distinguished e.g. 12/25/15 where it is obvious which is the day & which is the month as opposed to 2/2/15.
I need to be able to see formats 12/10/18 AND 12/11-14/18. But typing in MM/DD-DD/YY, MM/DD/YY does not recognize the latter (single dates). What should I do to get both formats recognized in the same column?
does anyone know how to show the date ordinal text, like if i want it to show 'January 21st' or 'January 22nd' or 'January 23rd' or 'January 24th'? I got the 'MMM D' part. but i don't know how to show that 'st' or 'nd' or 'rd' or 'th'. (shrug) I am simply not impressed (at all) with how LibreOffice chose their date/time format codes. :(
Thanks man, the first 30 seconds of this video was all I needed.
Excellent
Thanks great info, may I suggest you use a date where the Month & Day are easily distinguished e.g. 12/25/15 where it is obvious which is the day & which is the month as opposed to 2/2/15.
Amazing!!
I need to be able to see formats 12/10/18 AND 12/11-14/18. But typing in MM/DD-DD/YY, MM/DD/YY does not recognize the latter (single dates). What should I do to get both formats recognized in the same column?
hello, how to insert macro code for automatic conversion to hh:mm?
does anyone know how to show the date ordinal text, like if i want it to show 'January 21st' or 'January 22nd' or 'January 23rd' or 'January 24th'? I got the 'MMM D' part. but i don't know how to show that 'st' or 'nd' or 'rd' or 'th'. (shrug) I am simply not impressed (at all) with how LibreOffice chose their date/time format codes. :(
hi see error 0,:25 - correct 06:00 - how to fix?
i getting hashs