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 <off...@michiganpsychotherapy.com>
Date sent:Mon, 8 Aug 2022 09:51:51 -0400
Send reply to:will...@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+unsubscr...@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:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
--
To unsubscribe e-mail to: users+unsubscr...@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
