I have 2 Number type columns that represent minutes.
[Number_1] and [Number_2]
The max value of each column is 60.
In a Virtual Column I want to add up these 2 values to get a Duration type.
[Number_1] or [Number_2] can be empty.
I want to ignore seconds.
What is the best way?
This is what Iโve done:
TIME("00:"&(0+[Number_1]))-"00:00"
+
TIME("00:"&(0+[Number_2]))-"00:00"
Looks good to me!
Thank you @Steve for confirming.
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |