Challenge #10: Date Time Calculations

[KGS]

Hi,

Attaching the solution. Formula used is Datetimediff.

Best,

G

[TiwariVaishali]

Solution attached

[hieu_hoang]

Finished this challenge with only one Tool. Kinda similar ideas to some people but I guess the calculation is a bit different. 

[Junya_Wang]

Spoiler

just realize that the datetimenow made the answers different haha

[maureenfbrennan]

Didn't use the MOD function, but long hand version of the same approach.  🙂

[alexnajm]

I did it a little differently than everyone else (and the outputs don't exactly match because of the known error), but it works like a charm!

[coracai]

My solution. 

[EricaR]

Solution Posted

[MichaelSu]

See attached.

[devX511]

Used DATETIMEDIFF & MOD. Boom!