This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, this morning it seems that the formula “DATETIME_DIFF(End, Start)” express the result in minutes and no more in seconds as before.
The “Start” and “End” fields are Date fields in ISO format with a 24h date field.
An Exemple:
Start = "2016-07-19 0...
Hi,
in the screenshot below, i have a start date field and a formula field that give the number of seconds of the moment (an end date field exists but is hidden).
I would like to get the duration by day (and/or year/month/week… you get the idea) but ...
Hi,
i can’t get the integer part of the result of a division.
The aim is to transform for exemple 5400 (a number representing seconds) in that string: “1h 30mn”.
To get the hours, i divide 5400 by 3600. The result is 1.5.
Using the ROUND function doe...
Hi,
no worry for the late reply, it’s just a little experiment that occupy me when i have time for it, and that’s not really the case right now :slightly_smiling_face: So there is no urgency whatsoever. And thanks for the reply!
What i want to do i...
Hi, thanks for the reply!
i guess my explanation and question were unclear as i got 49 view but only 1 feedback :slightly_smiling_face:
Anyway, if i understand what you suggest, it would format my “Début” field (see below an exemple with the DATEFO...
You also could do (i didn’t test it though but used that NOT() function in another context):
IF(NOT({Finish Date} = ""), DATETIME_DIFF({Start Date}, {Finish Date}), DATETIME_DIFF({Start Date}, TODAY()))
Hi, thanks for the reply.
It work if i know beforehand the value of the division, but it was an exemple.
My question was more abstract: I have that formula seconds / 3600, how to get the nearest integer from the result?
Finally, i have resolved my pr...
