Bob Forrester
- Total activity 8
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 5
Activity overview
Latest activity by Bob Forrester-
Bob Forrester commented,
Or you can do it all in one column.... CONCAT( TIMESTAMPDIFF("DAY";#A;#B) ; "d "; MOD(TIMESTAMPDIFF("HOUR";#A;#B);24) ; "h "; MOD(TIMESTAMPDIFF("MINUTE";#A;#B);60) ; "m")
-
Bob Forrester commented,
Really easy , all you need is TimestampDiff and Mod. First we have 2 times in different columns: Next we will use TIMESTAMPDIFF to find days apart: Then we will use MOD with TIMESTAMPDIFF to get...