Schedule hours total

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
 
P

Peo Sjoblom

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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top