I am trying to create a formula so that it calculates time to the hundredths of a minute based on the conditions below. The best someone was able to do was to give the result in 3 separate columns - 1 column displayed the hours, one displayed the minutes and one displayed the total hours. However, I really need the result to to be in 1 column.
If L = 0 then 0
If P = F then subtract I from H and display in 100ths of a minute
If P is > F, then subtract I from AC1 (midnight) and display in 100ths of a minute
This is the formula I currently have. I couldn’t figure out how to add the second condition.
=IF(L2=0,0,IF(P2=F2,L2,HOUR($AC$1-H2)+MINUTE($AC$1-H2)/60))
If L = 0 then 0
If P = F then subtract I from H and display in 100ths of a minute
If P is > F, then subtract I from AC1 (midnight) and display in 100ths of a minute
This is the formula I currently have. I couldn’t figure out how to add the second condition.
=IF(L2=0,0,IF(P2=F2,L2,HOUR($AC$1-H2)+MINUTE($AC$1-H2)/60))