I was wondering if someone could help me develop a formula to count the hours when formatted in such a way:
<tbody>
</tbody>
I can do it with a million LEft( and Right( but that seems terribly clunky and prone to possible error.
Name | Hours | Monday | Tuesday | Wednesday | Thursday |
Name 1 | =Formula | 8am-8pm | 10:30pm-6:15am | etc | etc |
Name 2 | |||||
Name 3 | |||||
etc | |||||
<tbody>
</tbody>
I can do it with a million LEft( and Right( but that seems terribly clunky and prone to possible error.
Last edited: