At 09:51 08/08/2022 -0400, Bill Drescher wrote:
On a spreadsheet I want to multiply time worked in hh:mm by pay rate
(integer) and I can't find out how.
This is not a perfectly defined problem, I'm afraid. I'm guessing
that the pay rate is per hour: is that right? In that case, your
problem reduces to extracting a time value as a real number, so that
an hour and a half, say, appearing as 01:30 is converted to simply 1.5.
And what do you mean by "time worked in hh:mm"? If you mean that your
values are proper spreadsheet time values formatted as HH:MM, then
the underlying values are actually fractions of a day. The VALUE()
function will convert these values into normal numeric form, so your
01:30 will become 0.0625, as an hour and a half is that fraction of a
day. Just multiply by 24 to get hours, so VALUE()*24 will give the
In fact, the VALUE() function will reinterpret text values, so if you
have text values that *look like* times, this technique will still
work. And it even works for time values over twenty-four hours. Note,
though, that 25 hours will appear as 25:00 as text and as 01:00 (1
a.m. the following day) as a Time value formatted as HH:MM. Use
[HH]:MM instead if you want to see 25:00.
In short, =VALUE(Xn)*24*payrate should work for any of these situations.
I trust this helps.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
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