I cannot get the formula for calculating duration of time to work. I type it just as you have it on here and it shows "invalid data type". Any clue what I'm doing wrong?
Really helpful, but is there a trick to put in a workhour target like 08hours and 15minutes and get the difference of the workhour target and the actual hours I worked so that I can get the overtime like this?
@@vanessahock4200 if you need to always get a positive number as the result, you can wrap the formula that gives you a negative value in the ABS() function.