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

± is not a time/date value it should be formated as a 
regular number and would show 8.75
8 hours and 45 minutes
Values in time format versus values in number format.

08:45:00 AM</font>
06:00:00 PM</font>

The 8.75 gets converted to 8 being the number of days, 
and the .75 is 3/4 of a day being 18 hours, so isn't a 
time/date value. But is the correct value to multiple by 
the pay rate.

On 13 Aug 2022 at 14:15, bill wrote:

From: &#160;bill &lt;>
Date sent:60;Sat, 13 Aug 2022 14:15:55 -0400</span>
Send reply
Subject: ;Re: [libreoffice-users] multiplying time
To: 0;

On 8/8/2022 10:46 AM, Michael D. Setzer II wrote:</div>> > 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)

I am missing something.
in B1:  A1/ TIME(1,0,0)
If I put 08:45 AM into A1 the result I get is 06:00 PM in B1.


On 8 Aug 2022 at 9:51, bill wrote:

From:bill <>
Date sent:Mon, 8 Aug 2022 09:51:51 -0400> > Send reply
Subject:[libreoffice-users] multiplying time</div>> >

On a spreadsheet I want to multiply time worked in hh:mm by pay
rate (integer) and I can't find out how.</div>> >>
Help please.

Bill Drescher
william {at} TechServSys {dot} com


Bill Drescher
william {at} TechServSys {dot} com

Michael D. Setzer II - Computer Science Instructor (Retired)   60;                      &#160;
Guam - Where America's Day Begins                    &#160;
G4L Disk Imaging Project maintainer

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.