in excel, and in most RDMS dates and timestamps are basically numbers, where 1 is equal to 1 day, anything less than a day is just a the decimal decimal part… therefore as a human-readable sample:
1.0 = 1d
1.5 = 1d 12h
3.25 = 3d 6h
In excel, right now the time 19/01/2022 16:28:31 is a numeric value of 44580,6864690972 and the decimals go on and on…
If your division is not truncating the decimal part (and I don’t think so), you already have the time.
In this case I think excel is just hiding it behind formatting… because taht’s what excel does most of the time… change the format and use a custom one like dd/mm/yyyy hh:mm:ss or just set the column as a number and you will see the full data.
when dealing with the DB you can use the numeric format just fine most of the time
