Forum Discussion
Solved
help with formula
I have a spreadsheet with several tabs of data. I am wanting to count column L for time in minutes and divide it by 60 to get hours in the time period specified on Tab Injury Prevention. My current f...
Dania1215 This is the formula that checks for both begin and end date.
=SUMIFS('Summary of Services'!L2:L9988,'Summary of Services'!A2:A9988,">"&'Injury Management'!D3,'Summary of Services'!A2:A9988,"<"&'Injury Management'!F3)/60
I get 5 hours, which is what I think you are getting (you didn't say exactly where your formula was, but it appears to be on the Formula Totals tab, cell A58)?
The summary of services worksheet only has dates through row 7, but has times through row 9 (though the minutes in rows 8 and 9 total 135 and not 180). Is that worksheet complete?
If that's not it, then can you clarify exactly where your formula is located and what result you are expecting?
The summary of services worksheet only has dates through row 7, but has times through row 9 (though the minutes in rows 8 and 9 total 135 and not 180). Is that worksheet complete?
If that's not it, then can you clarify exactly where your formula is located and what result you are expecting?
- Thank you for your response.
I am trying to total the time in COlumn L on the Summary of Services page for the time period that is typed in on the Injury Management Page. So from 2/1 to 2/28, I want to know how much time was spent in prevention. (Total formulas page-A58). Then I want to take those minutes and divide by 60 to get hours. However, when I do this manually, i get a completely different answer that is 180 minutes off.
