Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Don't count 0:00h as 24h
Hi, i have a table in which counts the hours that are in a period that i
define, i had a precious help, that have gived me this formula: =MAX(MIN(MOD(B1,1),$N$1)-MAX(MOD(A1,1),$M$1),0) A B C D M N 1 18:00 21:00 Ponta 1:00 20:00 0:00 2 21:00 0:00 Cheias 3:00 And it works, except if i put 0:00 in N column, final term. The problem is that in column D2 it doesn't appear 3:00 it appears 0:00, because he can't recognize 0:00 as 24:00, ando so returns 0:00. The format is h:mm. Anyone knows how to solve this problem? tks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions |