I made a Saved Search and one of the columns is a Formula(numeric) that is subtracting 2 days. (ie. {enddate} - {startdate}). The result is some long decimal number like 0.00038938284781111818. Does anyone know what this is a decimal of? Like is this saying the result is .0000389 of a day? (or 24 hours). So if I wanted to convert this into minutes I would just multiply by 1440 to get minutes? Thanks

What is your expected outcome? Do you want just a formatted date? MM/DD/YYYY?

No I want to get the time between the two dates in hours or minutes but I don't know what that decimal is. I'm thinking it's days but I'm not sure

you can try doing this ABS(TO_DATE({trandate})-TO_DATE({datecreated}))