Challenge #10: Date Time Calculations

[mceleavey]

Hi @Kirstyp,

If you have converted your two date fields to actual datetime format using the date parse tool, you can build a formula using datetimediff(datetimeA,datetimeB,"minutes") which will give you the difference between the two regardless of whether it goes over to the next day.

[Kirstyp]

Great, thanks very much for your help.

[PhilipMannering]

Solution attached.

Spoiler

[dheerajpoojari]

Attached solution with one formula field(3 formulae)

[jamielaird]

Here's my solution.

Spoiler

[Natasha]

Spoiler

Used MOD function as well

[JacobR77]

Close but no cigar for me. Didn't know about the modulo function so used Floor instead, which got me close but not 100%.

[BenMoss]

This one was good, never had a usecase for the MOD function before so was handy to get some practice with this.

Spoiler

[patrick_digan]

Spoiler

Just used a bunch of datetimediff functions and subtracted the parts.

[MaxGiegerich]

I find the solution provided here quite confusing and requires a great deal of unpicking. Mine I find intuitive (but then I would I suppose...). For each subdivision:

• Add the previous subdivision(s) to the timestamp
• Take a datetimediff between the TIMESTAMP and the new Time_Now.

Done.