Use D3 Format date features for metrics using non-date columns

What is the problem or goal the end user is trying to solve or accomplish?

The customer is trying to apply a date format (HH:MM:SS) to a column stored as int data type and using the result with aggregate functions

How are they solving it currently?

There is no feasible workaround

What is the recommended solution by the Customer?

Implement the option to use D3 "date" Formats to metrics using columns with int values