StableN/ASyncedN/A

(HH:MM) Conversion of a field in SQL to Hours and Minutes

Updated Jun 9, 2026122 viewsView on usehalo.com
  • hours
  • HH:MM
  • Minutes

Converting a decimal hours field to an Hours and Minutes field

,left(CAST(CONVERT(VARCHAR,DATEADD(SECOND, {INSERT YOUR DECIMAL HOURS FIELD HERE} * 3600, 0),108) AS TIME), 5) as [Insert Field Name]