Hello Dear Community!
I am having not much fun concatenating minutes into hours.
In the image, where it says (for example) 75.16 minutes in line 4, I would like it to say 01:15 (or even 01h:15m.
My formula is below. I know it’s something to do with ...
Use case:
At the end of my estimates (page designer), I want to put in an inspiring or humourous quote… but I don’t want to type it myself, just collect them in a field somewhere and have them appear with a formula.
What kind of formatting/formula wo...
Phew! Lets’s see if I can explain this clearly.
Almost daily I go running.
I keep a log of distance and time and get a kick out of recording and graphing the results.
In Airtable, I’m using the chart app to chart several bits of data (DIstance, Time,...
I think I’ve bitten off more than I can chew.
I want my data in Airtable to flow into a snazzy PDF invoice.
My data is spread across several tables (!) and now I need help to unpick my knotted CRM to enable this task.
For example…
Every invoice goes ...
Hello Airtablers!
For my CRM I’m trying to automate the ranking of my prospects from “ :fire: Flaming hot” to " :skull: Dead".
I tried using a SWITCH formula but got in difficulties, so I reverted to IF and DATETIME_DIFF.
I want to switch between ...
Brillant - thanks!
I think I thought a chart couldn’t reference a formula - guess I was wrong!
Now if only I could make a chart showing minutes and seconds instead of just seconds - that yould be perfect!
Sure!
Firstly, here’s the base:
,
And here’s the first instance of numbers not converting (copying, as the field is a duplicate) from mins to sec…
Let me know if you need more!
Where would a beginner go about learning this in an step-by-step way?
Experience = 0. I mean, as Lisa Simpson says: „I know those words, but that sign makes no sense!“.
Edd Turner
Übersetzer, Dolmetscher, Sprachenberater und Dozent für Englisch
M: ed...
