Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two input box. 1- for number of days worked , 2 - for the number of days in field (for sales people)
The data entered is in number format and I want to multiply it into 9.5 and change it to hours.
Any idea of how this can be achieved. ?
ok, I didn't understand it right, then it should be:
=Interval(vWorkingDays*9.5/24, 'hh')
or
=Interval(vWorkingDays*9.5/24, 'hh:mm') // If you want also minutes
Hi shena, in example, if the variable is named vWorkingDays you can use this expression:
=vWorkingDays*9.5*24
If create another variable for it. For example if vVar is the variable which is linked to your current inputbox, create
vVar2 = vVar * 9.5
I might not have understood your requirement well enough, but seems like this is what you wanted.
HTH
Best,
Sunny
Thanks Ruben and Sunny,
I did use the logic mentioned. But again,
if I choose the number of working days to be 18 and multiply it with 9.5 = 171(this is number and not hours) how to change 171 to 171:00 ?
Is there a way to change it? I tried - Date(vWorkingdays*9.5, 'hh:mm') but it did not convert to the right value.
Hi,
Create 2 different variables:
one variable(Var_1): Working days input box
second variable(Var_2): while creating enter the expression like Var1*905
Now create one more input box with var_2
Now based on the Working days the infield days will change
ok, I didn't understand it right, then it should be:
=Interval(vWorkingDays*9.5/24, 'hh')
or
=Interval(vWorkingDays*9.5/24, 'hh:mm') // If you want also minutes
Use Interval Function
=Interval(vWorkingDays * 9.5/24, 'hh:mm')
Awesome, it worked. Could you please explain why we divide the value by 24? is it to denote the number of hours in a day?
Yes, dates and times are really a number and the base unit is 'day', so:
1 = 1 day
1/24 = 1 hour
1/1440 = 1 minute