Re: Multiplying Time by Numbers

[Alan Pearce]

Thanks Johnny.

On 19/03/2017 11:18, Johnny Rosenberg wrote:

When you enter time in a cell, enter it like hh:mm:ss (separator depends on
your language settings).
Examples:
0:0:9 → 00:00:09
0:9 → 00:09:00
9:0 → 09:00:00
1:13:3 → 01:13:03
12:4:56 → 12:04:56

the cell will format to hh:mm:ss automatically. Of course you can change
this. I guess h:mm would be what you're looking for. In that case, the
avove examples will display as:
0:00
0:09
9:00
1:13
12:04 (for some reason the result is not rounded up to 12:05, maybe that's
a bug, or maybe it's expected behaviour)

What's really in the cell is a floating point number less than 1. 1 means
24 hours, so 0.5 is 12:00:00, 0.75 is 18:00:00 and so on. To get it in
hours, just multiply with 24. Then you get something that you can multiply
directly with anything, such as your currency.

Here's an example
A1 → type 1:30
B1 → type 40 → format as currency
C1 → type =A1*24*B1 → formatting as currency will happen automatically.
Result: £60.

Simple as that…



Kind regards

Johnny Rosenberg



2017-03-19 11:37 GMT+01:00 Alan Pearce <alannpea...@talktalk.net>:


Thanks to all who replied to my request. I am sure that I will be able to
sort out a method now.

Regards,
Alan.

Sent from Samsung tablet

 Original message 
From: Alan Pearce <alannpea...@talktalk.net>
Date:18/03/2017  12:51  (GMT+00:00)
To: users@openoffice.apache.org
Subject: Multiplying Time by Numbers

I would like to multiply Hours and Minutes by a number of GB pounds. Is
this possible and if so how please?


Alan.

Sent from Samsung tablet



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Multiplying Time by Numbers

[Johnny Rosenberg]

When you enter time in a cell, enter it like hh:mm:ss (separator depends on
your language settings).
Examples:
0:0:9 → 00:00:09
0:9 → 00:09:00
9:0 → 09:00:00
1:13:3 → 01:13:03
12:4:56 → 12:04:56

the cell will format to hh:mm:ss automatically. Of course you can change
this. I guess h:mm would be what you're looking for. In that case, the
avove examples will display as:
0:00
0:09
9:00
1:13
12:04 (for some reason the result is not rounded up to 12:05, maybe that's
a bug, or maybe it's expected behaviour)

What's really in the cell is a floating point number less than 1. 1 means
24 hours, so 0.5 is 12:00:00, 0.75 is 18:00:00 and so on. To get it in
hours, just multiply with 24. Then you get something that you can multiply
directly with anything, such as your currency.

Here's an example
A1 → type 1:30
B1 → type 40 → format as currency
C1 → type =A1*24*B1 → formatting as currency will happen automatically.
Result: £60.

Simple as that…



Kind regards

Johnny Rosenberg



2017-03-19 11:37 GMT+01:00 Alan Pearce <alannpea...@talktalk.net>:

> Thanks to all who replied to my request. I am sure that I will be able to
> sort out a method now.
>
> Regards,
> Alan.
>
> Sent from Samsung tablet
>
>  Original message 
> From: Alan Pearce <alannpea...@talktalk.net>
> Date:18/03/2017  12:51  (GMT+00:00)
> To: users@openoffice.apache.org
> Subject: Multiplying Time by Numbers
>
> I would like to multiply Hours and Minutes by a number of GB pounds. Is
> this possible and if so how please?
>
>
> Alan.
>
> Sent from Samsung tablet

Fwd: Multiplying Time by Numbers

[Alan Pearce]

Thanks to all who replied to my request. I am sure that I will be able to sort 
out a method now.

Regards,
Alan.

Sent from Samsung tablet

 Original message 
From: Alan Pearce <alannpea...@talktalk.net> 
Date:18/03/2017  12:51  (GMT+00:00) 
To: users@openoffice.apache.org 
Subject: Multiplying Time by Numbers 

I would like to multiply Hours and Minutes by a number of GB pounds. Is this 
possible and if so how please?


Alan.

Sent from Samsung tablet

Re: Multiplying Time by Numbers

[Julian Thomas]

> On Mar 18, 2017, at 08:51, Alan Pearce  wrote:
> 
> I would like to multiply Hours and Minutes by a number of GB pounds.

Be thankful that you don't need to deal with pounds shillings and pence!  All 
you need to do [as was pointed out] is convert time to minutes and adjust your 
cost/hour figure to make it cost/minute.


Julian Thomas   - http://jt-mj.net

People are like stained glass windows: they sparkle and shine when the sun is 
out, but when the darkness sets in their true beauty is revealed only if there 
is a light within. - Elisabeth Kubler-Ross 






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Multiplying Time by Numbers

[Rory O'Farrell]

On Sat, 18 Mar 2017 12:51:39 +
Alan Pearce  wrote:

> I would like to multiply Hours and Minutes by a number of GB pounds. Is this 
> possible and if so how please?
> 
> 
> Alan.

You will need to convert your time (HH:MM) to a decimal fraction, before 
multiplying it by the hourly rate.  This tutorial will explain how OpenOffice 
handles time values.  The values you multiply must be numbers, not string 
representations of numbers.

https://forum.openoffice.org/en/forum/viewtopic.php?f=74=82181
-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Multiplying Time by Numbers

[Alan Pearce]

I would like to multiply Hours and Minutes by a number of GB pounds. Is this 
possible and if so how please?


Alan.

Sent from Samsung tablet