Challenge #10: Date Time Calculations

[etechman]

For some reason this one really threw me for a loop.  Nonetheless I still got a solution finally.

[LukasJennings]

Spoiler

Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days') Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([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)

Days = DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours = DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([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)

[Sashikumar]

Nice.

Spoiler

[Blair_A]

Here's my solution for this challenge. I did update the task input data to be the same as the output data.

Spoiler

[navneetmohit]

This is the shortest method I could think of. Will appreciate if someone could comment on this to tell me if I was right or wrong.

[greggrimmer1]

Spoiler

[A2H]

Spoiler

[WernerE]

Nice one, Thanks

Spoiler

[michael_leoni]

Spoiler

Please see my solution below. 

[MikeLR]

I went for separate formula tools for each step

Spoiler