Convert Number Hours to duration

AppSheet AppSheet Q&A
21

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

1 Like
22

Grant_Stead:

*1.0 and it’ll force it to decimal for calcs

Affirmative

1 Like
23

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

1 Like
24

Grant_Stead:

Appsheeple

1 Like
25

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.

26

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)