2022 Archives by date, by thread · List index

# 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>
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>> >>

--
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/