I'm ultimately trying to get a duration and a...

[Nathan_McGregor]

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:

1. Converts a duration to a decimal: =Hour([Hours worked at First job])+Minute([Hours worked at First job])/60

2. 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?