need a formula

T

Terry

need to find the formula for b3 is 8 hrs c3 = -.50min / b3 is less than 8hrs
c3 -.25 example b3 8. hrs c3 7.5 hrs / b3 6. hrs c3 5.75
 
B

Bernard Liengme

Terry: take a big breath and retype this slowly using punctuation and line
feeds. We do want to help but this makes no sense to me Unlike cell phone
text messages, there is no word-count cost.
best wishes
 
P

Pete_UK

I agree with Bernard, but I think what you need is this in C3:

=B3-IF(B3<8,0.25,0.5)

Hope this helps.

Pete
 

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

Need help calculating probabilities 7
Need Help with Excel and Flagging Outcomes! 4
If OR formula 1
trouble with (complicated) vlookup searching another workbook 2
Calculate hours, past midnight etc 4
Need formula for calculating time 2
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
series of formulas to get to one formula 0

Top