Hi community. I would like to see if anyone in the community can help me create a Libre Office cal sheet. I have it in .numbers file format but when trying to open it in libre office the formulas don’t work. In moving into more open source programs I would like to have a libre office version of it.
I work as a freelancer and I get paid by the minutes. So for example 0.35 a minute woule be $21 dollars an hour.
I would post an image on how its set up on numbers but basically i would have 5 columns vertically Date - > Hours - > Minutes → $ - > paid by minutes.
Then each column will have 31 rows for 31 days of a possible calendar months. My end goal is for me to input the hours worked and then it will calculate it to minutes and then $. The fifth column is where I would put the numerical value paid in minutes it could be .35 , or .45 or .65 ( these are cents but it could possible go to whole dollar amt .) you get the idea so based on that numerical value it would calculate how much money I got paid based on the hours / minutes I worked. At the end of the columns I would like to have a grand total of each of the columns hours, minutes, and $ . I’m posting a picture so you can get an idea .Screen Shot
2020-09-02 at 2.39.28 PM.png|attachment(/upfiles/15990720422758844.png)
Screen Shot 2020-09-02 at 2.39.28 PM.png
I know people charge for this type of service. I would really love if I could get a template as I have no clue how to work with formulas and the person that created my numbers spreadsheet is no longer available.
----------July Time Sheet copy.numbers.ods
