Did you know Power Query can talk JSON? Well no they don’t actually talk to each other….but if you’re trying to pull those name-value JSON pairs from a text file or log file to put into a spreadsheet, you don’t need to write some Python script do this. And hopefully you ARE thinking twice about putting your company’s data into one of those free services on the Internet.
Monday, August 7, 2023
Monday, July 31, 2023
Create a Time Sheet - Google Sheets
Do you track time sheets for people? Want a quick way to track and add up hours worked? Also want to be able to share or collaborate on the sheet?
A good solution is to use Google sheets. The calculations are easy to do, and the sheet is all in the “cloud” and easily shareable.
I’ve cover two ways you can track time spent either in decimals so you can multiply by some rate like 10 bucks and hour. Or you can get the time spent in duration like 8 hours 10 minutes.
Monday, July 24, 2023
Create a Time Sheet - Google Sheets
Do you track time sheets for people? Want a quick way to track and add up hours worked? Also want to be able to share or collaborate on the sheet?
A good solution is to use Google sheets. The calculations are easy to do, and the sheet is all in the “cloud” and easily shareable.
I’ve cover two ways you can track time spent either in decimals so you can multiply by some rate like 10 bucks and hour. Or you can get the time spent in duration like 8 hours 10 minutes.
Subscribe to:
Posts (Atom)