Cycle Time - Converting minutes to hours and minutes

Trussell21_32

Hello,

I am trying to convert total minutes to hours and minutes but am having problems.

I am using the formula below, but in some instances it returns a number with 4 digits in the seconds column.

=INT([2023]@row / 60) + ":" + MOD([2023]@row, 60)

Lisa LS Kennedy

Round to no decimal places and it will give you whole minutes

=INT([2023]@row / 60) + ":" + ROUND(MOD([2023]@row, 60), 0)

Lisa Kennedy

Senior Consultant | Smartsheet Development

Prime Consulting Group

Email:info@primeconsulting.com