Convert Minutes to Hour and Minutes

Ask for Help
2

Yes, you can do that with a combination of math and template columns.
Assume your Total (105) is in a column called Total:

  1. Create an Hours column as a math column using the formula FLOOR(T/60), and substitute T for Total
  2. Create a Minutes column as a math column using the formula MOD(T,60), and substitute T for Total
  3. Create a template column with your desired display text, substituting in the Minutes and Hours values as appropriate.

Hope this helps,
Darren

7 Likes