IF Function

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

Guest

I'm working on time schedule worksheet. I would like to subtract 30 minutes
if the hours for that day is 6 or greater. then I would like to subtract 60
minutes if the hours for that is 8 or greater. How do I do this in one cell
with formula in to calculate the total time? Can it be done with the "IF"
function? Thanks
 
Hi
how have you stored your time values?. As Excel time values (format hh:mm)?
 
You must log in or register to reply here.

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

Conditional Formatting and cloring cells and date calculations 1
Excel Formula or equation 3
Workday Formula to include date 0
Subtracting time...again 2
Time Calculated minus breaks & lunch 2
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2
subtract hours 1
How do I set up a time sheet in Excel? 8

Back
Top