I'm trying to track time intervals with case reporting and everything has gone wrong from the start. Custom date time fields do not behave the same way as native ones. I had to create this formula to compare:

ROUND((CAST({custevent_date_case_reached_queue} AS DATE) - {date}) * 24 *60, 1)

. Only to find out that the

date

field is in military time, creating a negative value for times in the PM. Is there any way to convert a military date time to a regular date time with a formula? Do I need to create yet another custom field?

what are the values in the 2 columns you are using for your formula.

I'm sorry, I'm done for today and I'm actually taking a much needed vacation day tomorrow on account of stress. I'll have to repost.