Re: [libreoffice-users] multiplying time

± 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>
0.364583333333333
06:00:00 PM</font>
8.75</div>


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;office@michiganpsychotherapy.com>
Date sent:60;Sat, 13 Aug 2022 14:15:55 -0400</span>
Send reply to:william@TechServSys.com
Subject: ;Re: [libreoffice-users] multiplying time
To: 0;msetzerii@gmail.com


> 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.
>
> bill
> > 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</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;
mailto:mikes@guam.net                      &#160;
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins                    &#160;
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