Challenge #10: Date Time Calculations

[mestevez1]

Solution inspired from @DE0413 . Was scratching my head due to the 41 sec difference until I read the comments on the thread.

[Nikos_I]

Same one tool solution for me as well. Thought there would be a function for this as well. 😛

[bjkay30]

A similar solution to everyone else.  This is my first challenge completed!

Spoiler

Days:  DateTimeDiff([Time_Now],[TIMESTAMP],'days')
Hours:  DateTimeDiff([Time_Now],[TIMESTAMP],'hours')-([days]*24)
Minutes: DateTimeDiff([Time_Now],[TIMESTAMP],'Minutes')-([Hours]*60)-([Days]*1440)
Seconds: DateTimeDiff([Time_Now],[TIMESTAMP],'Seconds')-([Minutes]*60)-([Hours]*3600)-([Days]*86400)

[Niklas]

The DateTimeNow in the input and answer aren't the same, which made the checks initially not line up...

[ConradW]

Challenge 10 complete

[pawan_bagdiya]

Due to difference in Input and Output file, I use output file for calculation. Just one formula tool with 4 different formulas

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)

[FRANCK_ROUQUETTE]

Thank you for the exercise. To get the same result than the Output I had to add 41 secondes to the Time_Now in the Input. Here is my proposed solution.

[ErenErdogan]

Hi all,

I used a single formula block with the formulas below:

Spoiler

Days: DateTimeDiff([Time_Now],[TIMESTAMP],"days")

Hours: DateTimeDiff([Time_Now],[TIMESTAMP],"hours")-24*[Days]

Minutes: DateTimeDiff([Time_Now],[TIMESTAMP],"minutes")-([Hours]*60)-([Days]*24*60)

Seconds: DateTimeDiff([Time_Now],[TIMESTAMP],"seconds")-([Hours]*3600)-([Days]*24*3600)-([Minutes]*60)

Take a look.

Regards,

Eren.