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]
- Platform
Platform
Latest News
- Products
Software
HaloITSM
The unified Service Management solution, redefined for Enterprises demanding best-in-class results.
HaloPSA
Intuitive, all-inclusive PSA solution, built to transform and modernise the delivery of managed IT services.
HaloCRM
Unify customer-facing teams to boost leads, conversions and customer service with the all-in-one CRM.
Platform
Software
The unified Service Management solution, redefined for Enterprises demanding best-in-class results.
Intuitive, all-inclusive PSA solution, built to transform and modernise the delivery of managed IT services.
Unify customer-facing teams to boost leads, conversions and customer service with the all-in-one CRM.
Solutions
Resources
