We currently have a calculated field to pull the Planned Completion Date "time" for email deployments. It displays in 24:00 but suddenly it has stopped functioning properly and adds 4 hours to every Planned Completion Date "Time".
CONCAT(HOUR({plannedCompletionDate}),":",RIGHT(CONCAT('0',MINUTE({...