± 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
