Den tis 9 aug. 2022 kl 13:18 skrev Nathan Perkins < nate.eric.perkins@gmail.com>:
Bill, I am replying because I saw your post at users@global.libreoffice.org 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 nateperk1000@gmail.com 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: users+unsubscribe@global.libreoffice.org 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: users+unsubscribe@global.libreoffice.org 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