Den tis 9 aug. 2022 kl 13:18 skrev Nathan Perkins < [email protected]>:
> Bill, > > I am replying because I saw your post at [email protected] > > I don't yet understand how to reply to the general post I think you actually did, though. Kind regards Johnny Rosenberg > but I think I > have an easy solution for you. > > > > If HH and MIN are entered in separate cells, convert HH to min, add > additional min, convert hourly rate to by the minute rate (for example > $15.00 per hour = 1500 cents) do the math in cents and then convert to > dollars and cents using the modulo function in calc. > > I'm not sure if this is clear. I had a similar problem calculating feet > and inches. The above solution seems to work well. > > If the above is not clear let me know and I will work it out in a > spreadsheet and send it to you. > > > Nate Perkins > > [email protected] > > PS. Any guidance you can provide on how to post to the users forum would > be appreciated > > > > > /You wrote:// > //On a spreadsheet I want to multiply time worked in hh:mm by pay rate > (integer) and I can't find out how.// > // > //Help please./ > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
