calculate time to percentage

**devilonline** · 11-03-2010, 05:55 PM

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

**daddylonglegs** · 11-03-2010, 06:02 PM

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?

**devilonline** · 11-03-2010, 08:39 PM

sorry can you show me in this example?

thanks

**daddylonglegs** · 11-03-2010, 08:47 PM

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