Schedule hours total

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

I need help with a formula to figure total hours. This
is an example.
Week1 Monday Tuesday Wednesday
Allen 8-1 12-6 12-6 8-1
Kim 8-1 8-12 1-6 12-6
 
Design it differently and put each number in an individual cell, then you
can just
us subtraction. Although there are workarounds calculating your text values
I strongly recommend
use. I can't see any advantage using 8-1 and so on but I can see a lot of
problems using it

8:00 AM 01:00 PM

or

08:00 13:00

etc..
 
Back
Top