Hello fellow friendly fibery folk, In short - is it possible to easily manipulate date times using formulas, e.g. set / add / remove units of time. Pain: “Setting a duration involves lots of clicks” Idea: “Create a button that does some the hard work” E.g. Duration = 30 minutes, Duration = 1 hou…

Create an integer field called ‘Surplus’. Then make a button with the following actions: [image] The formulas are as follows: Minute(Now()) - (RoundDown(Minute(Now()) / 15,0) * 15) and DateTimeRange(Now() - Minutes([Step 1 Meeting].Surplus),Now() - Minutes([Step 1 Meeting].Surplus) + Minutes(…

Hi Chris, Apologies for my delay replying to this, I’ve been mulling it over! I am going to try and implement something along these lines. The main point I’ve been thinking about is this. Is there any way to have a locally scoped variable (e.g. within the formula)? It seems a bit brittle to add a…

It’s a fair point, and you’re not the first to recognise a need: [image] Variables in formulas Ideas & Features Hi, I have been writing some quite advanced formulas in Fibery: [Screen Shot 2021-01-01 at 1.08.23 pm] I found that after some time even I cannot figure out …

Untill there is a different solution, maybe Chat GPT is able to help you. Chat GPT is an AI software you can chat with. I’ve found is usefull to add a formula there when I don’t remember what is does with the question “Can you explain what this formula does” and than Chat GPT will explain it.

Formula to set a duration (DateTimeRange)

Get Help

Chr1sG January 19, 2022, 2:36pm 4

It’s a fair point, and you’re not the first to recognise a need:

Topic		Replies	Views
[✔️DONE] Date Ranges in Formulas Ideas & Features formulas	2	794	September 27, 2021
Additional Formulas functions Ideas & Features formulas	1	95	October 15, 2025
Result from formula to get end date from date range is wrong Bugs & Issues	8	1461	September 27, 2021
Timezone offset calculation API & Programming	9	5266	April 3, 2024
Convert text to number or date with formulas Ideas & Features formulas	23	2595	June 12, 2026

Formula to set a duration (DateTimeRange)

Related topics