LinkBack URL
About LinkBacks
Hi.
I want to to do this calculation but i cant.
its a time value and X its percentage
4:30 its 100%
3:20 its X
how can i calculate X value
thanks
Hi.
I want to to do this calculation but i cant.
its a time value and X its percentage
4:30 its 100%
3:20 its X
how can i calculate X value
thanks
Dpeends what 0% is
Assuming 0% is 00:00, X = 3:20 / 4:30 formatted as a percentage
I'm assuming your 3:20 and 4:30 are times stored in cells, so your formula would actually look like =A1/B1 - if not, you'd need to use timevalue to coerce strings to times - it would be better to put the times into cells though and use a formula as outlined.
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
the cells are times. but I cant do this formula. (4:30*100) / 3:20
with this i want to do if 4:30 hours is 100% 3:20 is X
thanks
so for you example what result do you expect? If 3:20 is in A1 then use Charlie's suggestion like this in B1, i.e.
=A1/"4:30"
Format B1 as % and result should be approx 74%, is that right?
Audere est facere
sorry can you show me in this example?
thanks
In C16 use this formula
=B16/B15
and format that cell to show percentage
That assumes that C15 will always be 100% and that zero is 0% on your scale. If C15 might be anything other than 100% change the formula to
=B16*C15/B15
Assuming 0% is 00:00, X = 3:20 / 4:30 formatted as a percentageum, no, I wouldn't recommend that.I cant do this formula. (4:30*100) / 3:20
thanks it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks