How do I calculate time

G

Guest

Employee Name Date Monday In Monday Out Tuesday In Tuesday Out Total

7:45 AM 4:15 PM 7:45 AM 5:00 PM 8:45 AM 0:45
I cannot figure out the formulas.
 
B

Bob Umlas

If Monday in is in C2:
=(D2-C2)*24+(F2-E2)*24 (etc)
then format the result as general.
Bob Umlas
 

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