Challenge #10: Date Time Calculations

[Ddee]

A few more steps than others, but straightforward to troubleshoot...

[kennetheng]

Cool challenge and good introduction to the DateTimeDiff function. 

I ended up using formulas where I took the difference between hours and then subtracted out [Days]*24. Got to the same place. 

Had a difference in seconds though, but when I do the calculation by hand, my answer seems to be correct, not what is listed in the text output. 

Interesting take though. Had to look up what a Modulo was when I compared my solution to the given solution. 

[john_miller9]

Checked out some other solutions afterwards and really appreciate the diversity in approaches by others who have solved this.  And the bonus is that I learned about the modulo function!

Spoiler

Hours:  DateTimeDiff([Time_Now],[TIMESTAMP],'hours') - ([Days]*24)
Minutes:  DateTimeDiff([Time_Now],[TIMESTAMP],'minute') - ((60*24*[Days]) + (60*[Hours]))
Seconds:  DateTimeDiff([Time_Now],[TIMESTAMP],'second') - ((60*60*24*[Days]) + (60*60*[Hours]) + (60*[Minutes]))

[phottovy]

Tested on both the Input and Output data since they seemed slightly different.

[Hannah_Lissaman]

My solution :)

[Greg_Murray]

solution attached

[arno_bürgin]

Solution attached. I went with a somewhat mathemical way.

[bnelly1987]

1 tool. 4 formulas

Spoiler

[Cosmin_S]

Soltuion attached.