Post Author: Domo
CA Forum: Formula
Running CR9.
I have two datetime fields, 'Case Logged' and 'Case Closed' and I need to calculate the time between the two in hours and mins.
Using a simple formula: datetime() - datetime() I get the difference between the two fields as a decimal value - e.g. 1.75 would be equal to 1 hour and 45 minutes.
I would like to create a formula to convert the decimal value into hh:mm - any help welcome!