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
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