Weekly Challenges

Tgigs · ‎08-24-2023

My solution attached.

mattbov92 · ‎08-30-2023

My Solution

gjjadhao · ‎09-01-2023

Spoiler

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

jpg34 · ‎09-16-2023

my solution

jpg34 · ‎09-16-2023

my solution

orangebomber · ‎09-17-2023

spoiler

Christina_H · ‎09-19-2023

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)

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 · ‎09-22-2023

Completed

williamnolan03 · ‎09-28-2023

Done

mertshepard · ‎09-28-2023

Solution attached.

Weekly Challenges

IDEAS WANTED

Challenge #10: Date Time Calculations