Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Good ol' 1 tool wunder. A round of applause for MOD
Had to use the solution file as input as DataTime_Now in input is 41 seconds earlier than output
A little more manual than I would have preferred, but it works.
Here is my solution - rather than using floor or mod I changed data type to fixed decimal to truncate the result of the calculation:
Step 1: Used DateTime Tool
Step 2: Formula Tool
DateTimeDiff= DateTimeDiff([DateTimeNOW],[DateTime],"seconds")
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)
My attempt - Multi Row formula to update Time Now Column (for accuracy). Four Column Formula using TimeDateDiff and subtracting the formula value at the appropriate conversion scale.
Updated with Formula configuration screenshot
Just the one tool this week: