Try this: =IF(MOD(B2-A2,1)>8/24,MOD(B2-A2,1)-1/24,MOD(B2-A2,1)-0.5/24)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks