I’m ultimately trying to get a duration and a decimal to interact but it’s not working:
I’ve set up two virtual columns:
Converts a duration to a decimal: =Hour([Hours worked at First job])+Minute([Hours worked at First job])/60
Subtracts two decimals to produce one (this is more of an error check): =([First machine finish hours] - [First machine start hours])
The ‘apparently’ successful outcome can be seen in the screenshot below.
The problem is that when I subtract these two numbers I get this:
=[NumHoursJob1] - [NumMachineHoursJ1] =4.51
Even worse is that if the duration [NumHoursJob1] is a round number such as 4, it will display ‘40’.
Can someone please help me explain the cause and solution?
Hi @Nathan_McGregor, You may wish to try the expression for 1 above
=Hour([Hours worked at First job])+Minute([Hours worked at First job])/60.00
Thanks for the reply. I tried it and the same problem persists.
Information that may be helpful is:
Case 1 NumHoursJob1 = 1 (from duration 1:00:00) NumMachineHoursJ1 = 0 [NumHoursJob1] - [NumMachineHoursJ1] = 10
Case 2- NumHoursJob1 = 1 (from duration 1:00:00) NumMachineHoursJ1 = 4 [NumHoursJob1] - [NumMachineHoursJ1] = 14
Case 3 NumHoursJob1 = 1.5 (from duration 1:30:00 NumMachineHoursJ1 = 4 [NumHoursJob1] - [NumMachineHoursJ1] = 1.54
It’s basically just adding a digit for [NumMachineHoursJ1] but I don’t know why.
Hi @Nathan_McGregor,Thank you for your more inputs. I did some testing with 2 decimal type numbers, one composed with HOUR and MINUTE components and the other with just a fixed number.
I added these two numbers and these are getting added as expected.
I will share some screenshots.
Column 1 :[TestDurHr]
Type:
Decimal
Column 2: {DurAddNumber]
Type: Decimal
Test results for the addition
Hope all the screenshots and tests help you in some way.
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |