Apr 27 2023 12:58 PM
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: Clinic hours starts line 54. The columns are A- F. I put an example of how we add the time. I can't get it to total for all the days - all the breaks.
1. Clinic Hours (ex. M 8am -5 pm) | |||||||||
FTE = | |||||||||
Mon: |
|
|
|
| 60 | ||||
Tue: | |||||||||
Wed: | |||||||||
Thu: | |||||||||
Fri: | |||||||||
Sat: | |||||||||
Sun: | |||||||||
Apr 27 2023 01:12 PM
SolutionI'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
Apr 27 2023 01:46 PM
Apr 27 2023 01:58 PM
Apr 28 2023 07:54 AM
Apr 27 2023 01:12 PM
SolutionI'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