Formula Problem

How about e6=24*(IF(C6>D6,D6+1-C6,IF(H6="x",D6-C6,D6-C6-0.02)))

(there are much better ways of doing this but I've spent about as much time on this as you spent titling your thread).

CC

Originally Posted by Cheeky Charlie

How about e6=24*(IF(C6>D6,D6+1-C6,IF(H6="x",D6-C6,D6-C6-0.02)))

(there are much better ways of doing this but I've spent about as much time on this as you spent titling your thread).

CC

Hi,

What are you getting at?

Originally Posted by DonkeyOte

Just to reiterate your existing formula can be simplified if you use:

MOD(end time - start time,1)

This caters for possibility of end time < start time and v-v...
(a trick I picked up from daddylonglegs).

then simply subtract 30 mins from above result wherever H does not contain "x"

multiply result by 24.

(CC was getting at the fact that "Formula Problem" was not overly descriptive...)

Thanks for your help.

The description got his attention though didn't it.