Saved Search Formula: Date/Time Difference in Days – Hours – Minutes – Seconds format

DAYS	TRUNC({date1}-{date2})
HOURS	MOD(TRUNC(({date1}-{date2})*24),24)
MINUTES	TRUNC(60((({date1}-{date2})24)-TRUNC(({date1}-{date2})*24)))
SECONDS	ROUND(60((((({date1}-{date2})24)-TRUNC(({date1}-{date2})24))60)-TRUNC(((({date1}-{date2})24)-TRUNC(({date1}-{date2})24))*60)),0)

Create a formulae text field and then concatenate all the above formula using || as a result column.

Leave a comment Cancel reply