Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index


I am replying because I saw your post at

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.

Nate Perkins

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:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.