title: Calculating Over Time and Late Time payments in excel
body: <p>I need some help with a formula to automate my over-time and late time salary calculations. I get a report from our system which is in the following format:</p>
  
  <p>"In Time" "Out Time" "Late" "Early" "OT" </p>
  
  <p>All of these have values in the hh:mm:ss format however the cell is formatted as General.
  The In Time has the time of the day I punch in.
  The Out Time has the time of the day I punch out.
  Late has the number of minutes I am late by from my check in time i.e. 10:00 not 10:15.
  Early has the number of minutes I am early by.
  OT has the number of hours and minutes I a work beyond my shift end time i.e. 6:00</p>
  
  <p>I was hoping to get one column to tell me how much my salary would be deducted if I am late by x minutes. To give you an example, my day starts at 10:00 and I can come as late as 10:15 without any deductions. However for every minute I am late after that, I get a deduction which is calculated by the number of minutes I am late multiplied by my per minute salary ((((10000/30)/8)/60).</p>
  
  <p>And in the second column, I was hoping to calculate how much additional salary I would get for my over time. For example, my shift ends at 6:00 and for every minute after 6:00 I am entitled to over time, which is calculated by the number of minutes I work over time multiples by my per minute over time rate (30/60).</p>
  
  <p>Please let me know if you guys could help me with this. This could be used by almost anyone who wants to make sure their salary is calculated correctly.</p>