How to get the division quotiant and remainder using calculated field?
I am wondering and could not find a way to find the number of days, hours , minutes and seconds from two date difference or from available seconds. If there is a pre-defined function, please direct me ( I am aware of formating the seconds field to select Days Hours Minutes Seconds, to get the result in one field). I am looking basically to calculate in separate fields.
I know there are predefined formula to calculate the Days, Seconds but I want to calculate the days and then hours from remainder second's and then minutes from hours remainder seconds and remainder seconds.