Working time calcualator sheet for Excel/OpenOffice
Especially if you are a freelancer who has to calculate the working time for the invoice, or an employee with flexible times, you might want to have a simple spreadsheet where you can just type in
It turned out that this wasn't as easy and straightforward as I thought. In fact it was hard to find such a spreadsheet; just some formulars spread over the web.
So, I made one myself some years ago. The sheet is made with OpenOffice for Mac and converted for Excel. You might include a simple multiplication of the total time with your hourly wage. You are welcome to suggest enhancements or report errors, of course.
Downlad the Working Time Calculation Sheet
⇒ for openOffice as ods ⇒ for Word as .xls
Side note: Use at your own risk, of course. No guarantees whatsoever. Functionality of the Excel sheet cannot be guaranteed.
| date | topics | Begin (HH:MM) | End (HH:MM) | (minus) break (HH:MM) | Total working time of the day (decimal) |
It turned out that this wasn't as easy and straightforward as I thought. In fact it was hard to find such a spreadsheet; just some formulars spread over the web.
So, I made one myself some years ago. The sheet is made with OpenOffice for Mac and converted for Excel. You might include a simple multiplication of the total time with your hourly wage. You are welcome to suggest enhancements or report errors, of course.
Downlad the Working Time Calculation Sheet
⇒ for openOffice as ods ⇒ for Word as .xls
Side note: Use at your own risk, of course. No guarantees whatsoever. Functionality of the Excel sheet cannot be guaranteed.
Trackbacks
No Trackbacks
The author does not allow comments to this entry
Comments
Display comments as Linear | Threaded