If I understand what you are looking at.
With A1 having 8:45
B1 having A1/time(1,0,0)
B1 would have decimal equivalent of time in hours
C1 would be B1 * $15 (example rate)
C1 would be 131.25 (8.75 * 15)
That would work if 24 hours or less.
If values more than 24 hours would need to more
Example:
a6=days as whole number
a6=2
b6=2:00 (time(2,0,0))
c6=(a6+b6)/time(1,0,0)
d6=c6*15 (50 * 15) = 750
Another example:
a9 =date(0,0,2)+time(2,0,0) Displays 12/02/99 02:00am
b9 =(a9-date(0,0,0))/time(1,0,0) Displays 50
c9 =b9 * 15 Display 750
On 8 Aug 2022 at 9:51, bill wrote:
From:bill <office@michiganpsychotherapy.com>
Date sent:Mon, 8 Aug 2022 09:51:51 -0400
Send reply to:william@TechServSys.com
To:users@global.libreoffice.org
Subject:[libreoffice-users] multiplying time
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.
--
Bill Drescher
william {at} TechServSys {dot} com
--
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
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mikes@guam.net
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
--
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
Context
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.