± 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:  bill <off...@michiganpsychotherapy.com> Date sent:60;Sat, 13 Aug 2022 14:15:55 -0400</span> Send reply to:will...@techservsys.com Subject: ;Re: [libreoffice-users] multiplying time To: 0;msetze...@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 <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</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: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