Skip to Content
0
Former Member
Jan 03, 2008 at 10:44 AM

Converting decimal value to HH:MM

241 Views

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!