Possible Array Formula?
I have a set of data:
Rows = Job Titles
Columns = Months
Values = Budgeted hours within the month
The hours are per month and per job title which means they can be quite high as we have more than one person in certain roles.
I want to get this data into a format to import into our time and attendance software as a budget – for ease I was importing all entries on the 1st of the month. (The day of the month is irrelevant as we will be looking at this data in monthly views). To import you have to enter start date and start time, it auto calcs the end time and date, however, the system does not handle values over 24 hours as it cannot auto calc that the end date is in a different day.
I want to find a way in excel to read my core data and if its over 24 hours add an extra line to the import file for that job title.
It has been mentioned that possibly an array formula can do this but I wouldn’t know where to start with this…..Any suggestions would be much appreciated please.
The first screenshot is the core data. The second is the import example – the one in red is the one that will fail.
I have a set of data:Rows = Job TitlesColumns = MonthsValues = Budgeted hours within the monthThe hours are per month and per job title which means they can be quite high as we have more than one person in certain roles.I want to get this data into a format to import into our time and attendance software as a budget – for ease I was importing all entries on the 1st of the month. (The day of the month is irrelevant as we will be looking at this data in monthly views). To import you have to enter start date and start time, it auto calcs the end time and date, however, the system does not handle values over 24 hours as it cannot auto calc that the end date is in a different day. I want to find a way in excel to read my core data and if its over 24 hours add an extra line to the import file for that job title.It has been mentioned that possibly an array formula can do this but I wouldn’t know where to start with this…..Any suggestions would be much appreciated please.The first screenshot is the core data. The second is the import example – the one in red is the one that will fail. Read More
