I’m not 100% but I think you can just *1.0 and it’ll force it to decimal for calcs…
Thanks @MultiTech_Visions you’re one of my favorite Appsheeple… Come on, that’s pretty good slang…
I mean can I avoid the *60 portions because I will never have part of a number. Numbers auto convert to decimal when doing math I believe.
If you’re never going to have a decimal portion of the hours, and you literally just need to “inject” the hours into the duration, you could do it this way:
NOW() - concatenate(left(“000” & [Hours], 3), “:00:00”)
I’m thinking that would work (but I haven’t tested that)