I have totaled the number of seconds for several cards and need to take the sum and show it as #Hours, #minutes.
I'm struggling to find a way to do this in beast mode. This is not converting a time value but altering the sum.
For example, if I have a total of 8,274 seconds
First, you find the number of whole hours
8,274 seconds = 8,274 seconds ÷ 3,600
8,274 seconds = 2.29833 hours
# of full hours = 2
Then Find the number of whole minutes
minutes = .29833 hours × 60 minutes
minutes = 17.9 minutes
# of full minutes = 17
So 8,274 seconds is equivalent to 2 hours and 17 minutes
How do I split the decimal value 2.17 so that I can multiply 0.29833 X 60