Time differences in percentage

[directx]

Hello everyone,

I have a simple request. I have 4 different times and I need a cell to display the difference between these 4 times in percentage.

For example

If time is

1:00 1:00 1:00 1:00 it should display 100% because time is same

0:45 0:50 1:00 1:10 it should display something like 60%, because of difference slowest and fastest. Ofc every of these 4 times can be slowest and fastest.

Table:

<a href="https://ibb.co/g8deGK"><img src="https://thumb.ibb.co/g8deGK/image.png" alt="image" border="0"></a>

Value of cells C9, E9, G9, I9 should be displayed in Balance top row
Value of cells D9, F9, H9, J9 should be displayed in Balance bottom row



Best regards

 

[JazzSP8]

You've not indicated the rows these are on so I've guessed at 4, but does;

=MIN(E4:H4)/MAX(E4:H4)

(Formatted as a percentage)

Do the trick for you?

 

[directx]

Wow, so simple. I was sure it will be more complex.

/facepalm

Thanks a lot mate!