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?