I have a very simple calculation to get time since the last record up to today's current time:
CURRENT_TIMESTAMP() - MAX(`sys_created_on`)
This seems to work fine and returns a time formatted like this for example:
How do i modify my formula to remove the ".0000" part?
I've written up a similar solution utilizing UNIX_TIMESTAMP, some simple math and the CONCAT function. I'd recommend taking a look at https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Date-Calculations-minutes-and-seconds/m-p/49259/hig.... That will give you a way to customize your display of the days, hours, minutes and seconds and strip off the decimals.