The right way to do it is convert HH:MM to seconds. Then calculate your billing rate PER SECOND (amount / 60), and multiply it with the first value.
At least that' s how I'd do it. Hope this helps... FC On 09/04/2022, rcrmon...@wi.rr.com <rcrmon...@wi.rr.com> wrote: > My pay is basically done by the minute. When I record the hours I > worked, it is expressed 11:55 or 11 hours, 55 minutes. When I record my > hours in OpenOfficecalc, I currently convert the minutes into fractions > of an hour--ie 55 minutes=.9166666--which I'm not sure is accurate. Is > there a way to multiply 11:55 by a dollar amount--say 9.75 to get the > exact dollar amount earned or am I doomed to always converting the > minutes to decimals? > > Dennis > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > -- ---- During times of Universal Deceit, telling the truth becomes a revolutionary act Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto Revolucionario - George Orwell --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
