Capture the total hours of each row in Excel Online
I want to capture the total hours spent on task, so basically, it's [Max Time] - [Min Time] in a table with inconsistent data. What's an optimal way to do this in excel online?
Problem: The data is inconsistent in its structure. Start time is usually in the [Start] column, however it's really the first time in a row. It's arranged this way to visually match a paper form, and it makes data entry easier for users.
The structure looks like the image below:
- Rows: Unique based on date, job and user
- Start, T1...T8: Time (of collection)
- C1...C8: Number (count of item)
I have accomplished other data analysis here using a series of IF() functions and helper columns, but it's hard to read and hard to change. I think there's a more elegant way to accomplish this by taking the columns and making an array but haven't figured it out yet.
[link] [comments]
Want to read more?
Check out the full article on the original site