Luiskis wrote: ↑Wed Jan 11, 2023 7:26 pm
I would like to make a macro that writes =ROUND(NOW()*288;0)/288. … I can't code at all and I don't understand anything about it.
Record a macro. See
[Tutorial] Favorite Recorded Calc Macros. You want a minor modification to
TimeStamp.
Category:Mathematical → Function:FLOOR → Next → Number:NOW()+1/576 → Significance:1/288 → OK
The recorded formula should be
=FLOOR(NOW()+1/576;1/288). I've tested this and it enters the desired formula into the currently selected cell.
If the result is intended to be
dynamic (constantly changing as you edit the sheet) omit
TimeStamp's Copy and Paste Special steps. I suspect most people want a
static timestamp (which never changes after it's created) and therefore
do want the Copy and Paste Special steps as shown in my
TimeStamp recorded macro. The choice is yours. Either way, recording the macro is very simple and requires no programming experience.
Luiskis wrote: ↑Wed Jan 11, 2023 7:26 pm
with the function hotkey
[Tutorial] Binding a macro: Shortcut key, menu or toolbar
If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).