Challenge #10: Date Time Calculations

[Gem]

Hi! You've probably gotten this note a bazillion times, but the input timestamps don't match the output ones. In my attempt to figure out why my results didn't match the output, I came up with two different methods/sets of formulas to solve the challenge. :D 

[daiphuongngo]

Completed

[Kinga]

Hi,

the column with Time_now in Input is slightly different then in Output. However, the solutions work correctly :) I have two.

Spoiler

Solution 1:

Solution 2:

[daiphuongngo]

Spoiler

 

[ivan_duniak30079]

Spoiler

Spoiler!

[NhungLe]

My solution using Floor function

[dwstada]

messy solution

[TungThanhHo]

my solution

[Liusaidhowen]

My solution

[ShankerV]

Easy one!!!

Here is my solution!!!