Re: Formula

2022-04-09 Thread PCS
I’m not a power user, I’m a ‘work-around’ person, and I've done something roughly similar to this before. Here are my work-arounds for this situation: Calculation work-arounds.ods Description: application/vnd.oasis.opendocument.spreadsheet PCS > On 9 Apr 2022, at 2:31 pm,

Re: Formula

2022-04-09 Thread Fernando Cassia
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 wrote: > My pay is basically done by the minute. When I

Formula

2022-04-09 Thread rcrmonte3
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=.916--which I'm not sure is accurate. Is there a way