How do I calculate time

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
If Monday in is in C2:
=(D2-C2)*24+(F2-E2)*24 (etc)
then format the result as general.
Bob Umlas
 
Back
Top