Donate SIGN UP

Exel Formulas

Avatar Image
pigface | 09:47 Thu 09th Feb 2006 | Technology
3 Answers
I want to know about IF formlas. I am creating a spreadsheet for time recording at work. I have one column recording the start time and one recording the end time. Another column is formatted to subtract the start from the end time to show the duration of the work.

I now need to split the duration into quarter-days. Can I use an IF formula for this purpose. For example, if duration = <3:00 then the value returns 0.25, if duration = >6:00 then the value returns 0.5.

Can this be done, if yes, how? ANy good websites?
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by pigface. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

It can be done! You will need to use a nested IF formula as follows...


=IF(duration<=3,0.25,IF(duration<=6,0.5,IF(duration<=9,0.75,IF(duration<=12,1,0))))


It should be easily adapted to suit your purposes!


Question Author
thankyou!

Well done Aquariel.


pigface, for future reference:-


http://j-walk.com/ss/excel/usertips/index.htm


1 to 3 of 3rss feed

Do you know the answer?

Exel Formulas

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.