[libreoffice-users] Reply hh:mm

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 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