PDA

View Full Version : Help with time diffrences



Rashidz
05-02-2018, 06:08 AM
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
05-02-2018, 07:13 AM
=(Max(F2,(3/24)) - Min(F2,(3/24))

Rashidz
05-02-2018, 07:40 AM
Thank you so much for the help SamT.

Problem solved :thumb

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

SamT
05-02-2018, 08:37 AM
Is there a way to make MAX value and MIN turn to color font?
Maybe with Conditional Formatting