Relative Content

Tag Archive for excelgoogle-sheets

Changing Script Google Sheets to script for Microsoft Excel

For data-analysis I am using Google Sheets. A company has developped a script to help us with this and to create automated reports based on these analysis. We would like to transfer our method from Google Sheets to Microsoft Excel, using the same output. Is there a way to translate the Google Sheet script to Microsoft Excel?

Google sheets – Calculating shift hours

The goal of this spreadsheet is to calculate total hours worked and out of that figure out how many hours has been in the day shift (from 6:00 to 22:00) and how many hours has been in the night shift (from 22:00 to 6:00).

Google Sheets – Multiple dropdown menus

I have some problem with the code.. I’m stuck on the third statement if “Overheights”.
I want to be able to sort by ‘Pick’,’Error’ and ‘Overheights’, but for the latter it doesn’t work exactly as planned? any ideas?