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

N

nocomputawizz

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
 
S

swatsp0p

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
 

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

Similar Threads

Formula difficulty 4
calculate finishing time if night shift aren't working 1
Help with a formula for a Time Sheet. 1
Calculate end date and time 1
formula help 3
formula for adding up 3 different start and finish times 4
IF Function formula (I think?) 4
Start, Finish including break time 2

Top