How to Add Time Formula Duration (hh:mm)

How to Add Time Formula Duration (hh:mm)

Hi everyone — I’m trying to create a formula field in Zoho CRM that calculates the difference between a “Call Start Time” and “Call End Time” and displays the duration in HH:MM format (for example: 1:04 for one hour and four minutes).

My current setup returns decimals (e.g., 1.07) which is incorrect. I’d appreciate guidance on:

  • The correct formula to use (DateComp, etc.)

  • Best return type (Numeric, String) for HH:MM

  • How to format the field so minutes display correctly (00‑59).

Thanks in advance for any help or examples!