How to go to next day in fomula of Time differences ?
 

I have the below formula where :
C7= TIME START
C8-=TIME FINISHED


=IF(OR(C5="Choice1",C5="Choice2",C5="Choice3",C5=" Choice4"),C8-C7,"0")*(24)

In the formula, near the END the:
TIME FINISH(C8) is Taken Away(minus) the TIME START(C7)
this gives me the Hours difference when the *24 is used.

I have discovered that if the TIME START is late in one day and the TIME FINISH spills over to the next day, i then get a NEGATIVE(-) value.
How can i get this formula to roll into the next day?


Corey...

How to go to next day in fomula of Time differences ?
 

(C8-C7+(C7C8))

i.e.

IF(OR(C5="Choice1",C5="Choice2",C5="Choice3",C5="C hoice4"),C8-C7+(C7C8),"0")*(24)

"Corey" wrote:

I have the below formula where :
C7= TIME START
C8-=TIME FINISHED


=IF(OR(C5="Choice1",C5="Choice2",C5="Choice3",C5=" Choice4"),C8-C7,"0")*(24)

In the formula, near the END the:
TIME FINISH(C8) is Taken Away(minus) the TIME START(C7)
this gives me the Hours difference when the *24 is used.

I have discovered that if the TIME START is late in one day and the TIME FINISH spills over to the next day, i then get a NEGATIVE(-) value.
How can i get this formula to roll into the next day?


Corey..