Convert Number Hours to duration

I’m not 100% but I think you can just *1.0 and it’ll force it to decimal for calcs…

1 Like

Affirmative

1 Like

Thanks @MultiTech_Visions you’re one of my favorite Appsheeple… Come on, that’s pretty good slang…

1 Like

:rofl:

1 Like

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)