Help with time diffrences

[Rashidz]

Hi,

Need help with formula for negative time differences.

Example 1. (SOLVED)

I have 4 different set of timing and my base is time 03:00:00

Cell B2 - 00:46:44
Cell C2 - 00:46:30
Cell D2 - 00:45:56
Cell E2 - 00:45:09

Total of all these 4 is 03:04:19, FORMULA - =SUM(B2:E2)

So the different is 03:04:19 - 03:00:00 = 00:04:19, FORMULA - =F2-(3/24)


Example 2 (NOT SOLVED and NEED HELP)

Cell B3 - 00:45:35
Cell C3 - 00:41:44
Cell D3 - 00:42:26
Cell E3 - 00:45:00

Total of all these 4 is 02:54:45, FORMULA - =SUM(B2:E2)

So the different should be 00:05:15 but i couldn't get the formula

[SamT]

=(Max(F2,(3/24)) - Min(F2,(3/24))

[Rashidz]

Thank you so much for the help SamT.

Problem solved

Last question. Is there a way to make MAX value and MIN turn to color font?

[SamT]

Is there a way to make MAX value and MIN turn to color font?

Maybe with Conditional Formatting