Welcome!

Help on a formula

Hi there,

I try to convert hours to duration, on a basis : 7 hours = 1 day.

I made a formula that has been working so far. But my boss asked me to add a minute setting. So that's my formula :

= IF(AND(Heures@row = "0,5"); 0,05;

IF(AND(Heures@row = "1"); 0,1;

IF(AND(Heures@row = "1,5"); 0,2;

IF(AND(Heures@row = "2"); 0,3;

IF(AND(Heures@row = "2,5"); 0,35;

IF(AND(Heures@row = "3"); 0,4;

IF(AND(Heures@row = "3,5"); 0,5;

IF(AND(Heures@row = "4"); 0,6;

IF(AND(Heures@row = "4,5"); 0,65;

IF(AND(Heures@row = "5"); 0,7;

IF(AND(Heures@row = "5,5"); 0,8;

IF(AND(Heures@row = "6"); 0,9;

IF(AND(Heures@row = "6,5"); 0,95;

IF(AND(Heures@row = "7"); 1))))))))))))))

So it works for whole numbers, but nothing is dispolayed if I select a decimal number.

Have you an idea ?

Thanks a lot for your help.

Find more posts tagged with

Comments

Paul Newcome

So you are wanting to figure out what percentage of 7 hours (for example) 3 hours and 52 minutes is?

Ptipok

Hello thanks for comment.

I would like only to convert hours and half an hour.

So for instance if someone works : 2H30,

- I would have 2,5 in my column "hours"

- It would represent 0,3 in my column duration for one day.

I don't know if I'm clear

Thanks for help

Paul Newcome

Ok. I am beginning to understand.

So 2H30 would equal 2,5 hours. 4H30 would equal 4,5 hours. So on and so forth.

How would 2 hours be displayed?

2H?

2H00?

Ptipok

2 hours is displayed 2

My formula works when it returns a whole number. So it works with 2.

But nothing appears when it returns a decimal number. So it doesn't work with 2,5.

You can see it in my screenshots. Yet, I used the same exactly the same code.

Paul Newcome

Have you tried removing the quotes from around the numbers?

Ptipok

Great it works ! It was so simple in fact

Thank you so much for your help. Have a nice day.

Paul Newcome

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Timeline Widget Filter on the Dashboard
The timeline widget seems to only allow filters to be set when you are editing the widget (see green highlight screenshot). Which is fine, but it would be more valuable to have regular users be able to adjust filters directly from the dashboard, similar to how there is an option to adjust the timescale. Am I missing…
“File Creation Restriction”
Hello There , before smartsheet switched to the new license type, the users to whom I gave editing permissions could not share the page unless I granted them permission. In addition, users did not have the ability to create pages. This way, as the admin, I was aware of all the pages created in the company and could…
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks