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 ...
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.
Every invoice goes ...
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!
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!“.
Übersetzer, Dolmetscher, Sprachenberater und Dozent für Englisch