I am replying because I saw your post at email@example.com
I don't yet understand how to reply to the general post 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.
PS. Any guidance you can provide on how to post to the users forum would
//On a spreadsheet I want to multiply time worked in hh:mm by pay rate
(integer) and I can't find out how.//
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] Reply hh:mm · Nathan Perkins
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy