Bcba hours spreadsheet4/3/2023 '2014-Stats'!C8 - Holiday hours for period '2014-Stats'!C27 - Total hours for period This sheet is used to reference values for my calculations. This seems very manual and the holiday hours for each period would need to be updated from year to year. This sheet also has the total number of holiday hours per period, per quarter, and per year. I'm using one sheet to list the total number of hours per period, per quarter, and per year. I've attempted to put together a spreadsheet to do this however, I've run into one problem (Although the numbers in the XLS exported from the time tracking program are not formatted as numbers and must have the text converted to numbers first.) This spreadsheet can be copied into my utilization spreadsheet in order to reference the number of hours for each employee. We use a time tracking platform that can export an XLS with a summary of each employee's hours for a given date range. Ultimately, I would like this spreadsheet to be a template that can be used for each year. I would like it to calculate utilization percentages for period (4-4-5 month schedule), quarter, and year. I would like to develop a spreadsheet template that can be used to calculate my employee's utilization percentages based on their billable hours. First and foremost, I've done some searching on this forum to find a solution to my problem but haven't located anything yet.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |