Challenge #10: Date Time Calculations

[AD]

Spoiler

[paulburrows]

An introduction to the mod function today 🙂

[Ronald_Do]

This exercise was a great way to learn the "Mod" command! 

[TwylaXBlack]

One Formula tool solution attached,

Spoiler

Spoiler

[maheensayeed]

Here's my solution

[puneet707]

My Solution

Spoiler

For days-         DateTimeDiff([Time_Now],[TIMESTAMP],"days")
For Hours-       DateTimeDiff([Time_Now],[TIMESTAMP],"hours")-[Days]*24
For Minutes-    DateTimeDiff([Time_Now],[TIMESTAMP],"Minutes")-[Days]*24*60-[Hours]*60
For Seconds-  DateTimeDiff([Time_Now],[TIMESTAMP],"seconds")-[Days]*24*60*60-[Hours]*60*60-[Minutes]*60

[jchua3]

solved with a longer method using regex but easier if it's hard to grapple with converting all the units together.

[LevL]

done

Spoiler