Challenge #10: Date Time Calculations

[DawnDuong]

Thanks for posting the challenge. I learnt that the datetimediff function only counts the "whole" part of the unit through this exercise. I used a slightly different set of formulas from the solution, but the idea is the same. I did not use the datetimeformat but it still seemed to work right as the datetime is already formatted with the right syntax.

Spoiler

[Loic]

Used simpler formulas I think :-)

[Eleonora]

My solution

Spoiler

[Awesomeville]

Modulo with datetimediff equates to game set.

[pfredin]

Here is my solution.

[mgcarrenard]

My solution. Similar to the proposed one.

[cgoodman3]

Once factoring in the difference in the Time_Now field this is what I've got. Few minor discrepancies due to rounding.

Spoiler

[rslopez2]

First time using DateTimeDiff Formula - Also learned the Modulo function from going through this challenge! 

[RobertoEstrada]

OK, this one was really easy. Not sure my solution is the best but it works.