Forum Discussion
Solved
I'm struggling trying to figure out this formula
I need to calculate the amount of hours available for the week by inputing the start and stop times along with the total amount of breaks (could be lunch, meetings off site etc) here is my grid: Cl...
I'd keep the arrangement for this very simple and eliminate the columns that show AM or PM. (Sample attached below)
=SUM((Fin-Start)-(BreakFin-BreakStart))*24
Is this what you meant? It's still not working for me? =SUM(((C57 Finish-B57 Start)-(E57 BreakFin-D57 BreakStart)+((C58 Finish-B58 Start)-(E58 BreakFin-D58 BreakStart)+((C59 Finish-B59 Start)-(E59 BreakFin-D59 BreakStart)+((C60 Finish-B60 Start)-(E60 BreakFin-D60 BreakStart)+((C61 Finish-B61 Start)-(E61 BreakFin-D61 BreakStart)+((C62 Finish-B62 Start)-(E62 BreakFin-D62 BreakStart)+((C63 Finish-B63 Start)-(E63 BreakFin-D63 BreakStart))*24
I created defined names for each of the 4 columns and then used those in the formula. The formula can be made much smaller with this method.
- I see that is much easier. THank you.
- You're welcome!