formula for start - finsh time -halfhour ifsum of start-finish>8

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am designing a spread sheet for staff payroll. Enter start time and finsh
time, if total is greater than 8 hours hours paid will deduct half an hour
off for unpaid break. New to formulas and i can't get this one sorted
apreciate any help
 
Assuming start time is in cell A3, finish time is in cell B3, in cell C
put this formula

=IF((B3-A3)>TIME(8,0,0),(B3-A3)-TIME(0,30,0),B3-A3)

Format all cells as Time > 13:30 and enter all times using the 2
hour format where 18:00 = 6:00 p.m. (this eliminates the need fo
entering A.M. or P.M. for each entry)

ht
 
Back
Top