Exel Formulas

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?

prev

Mobiles and Media Industry

next

Reporo online shopping on your mobile

Answers

1 to 3 of 3

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!

pigface

Question Author

thankyou!

wideboy

Well done Aquariel.

pigface, for future reference:-

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

1 to 3 of 3

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.