Challenge #10: Date Time Calculations

[Tgigs]

My solution attached.

[mattbov92]

My Solution

[gjjadhao]

Spoiler

Solution is attached......used CEIL and but seems Input TimeNow is different than Output TimeNow

[jpg34]

my solution

[jpg34]

my solution

[orangebomber]

spoiler

[Christina_H]

I adjusted the value of Time_Now to match the output for easier checking

Spoiler

Days: DateTimeDiff([Time_Now],[TIMESTAMP],"day")
Hours: MOD(DateTimeDiff([Time_Now],[TIMESTAMP],"hour"),24)
Minutes: MOD(DateTimeDiff([Time_Now],[TIMESTAMP],"minute"),60)
Seconds: MOD(DateTimeDiff([Time_Now],[TIMESTAMP],"second"),60)

[CurtisPaterson]

Completed

[williamnolan03]

Done

[mertshepard]

Solution attached.