How do I calculate time
 

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.

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

"Amy Forster" <Amy wrote in message
...
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.