Challenge #10: Date Time Calculations

[clintonang]

Think the result output file data is not as accurate but great support from the community. Use the formula tool as well to calculate.

[ArtApa]

Here is my solution:

Spoiler

[JP_SDAK]

Thanks Alex for the heads up.  Couldn't figure out why my times were off.  Checked and it's 41 seconds different for each.

[hema_sampath]

Spoiler

Days - DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours - DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-DateTimeDiff([Time_Now],[TIMESTAMP],'Days')*24
Minutes - DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")-DateTimeDiff([Time_Now],[TIMESTAMP],'hours')*60
Seconds - DateTimeDiff( [Time_Now],[TIMESTAMP],"seconds")-DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")*60

[SaâdEnnassiri]

Hello gents,

Cool exercice, thx

[szade1]

Here's my solution...

[rmforcreamlisa]

Here is my solution.

[sumanthskumar]

Challenge #49

Spoiler

[Tberney]

Threw me for a moment that the Time_now in the input is not the same as the one in the sample solution. Guess if I had read the thread first - but would that be cheating?

Spoiler

[matt_un]

Spoiler

First (and probably last) one with a single tool.