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

C

Corey

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...
 
T

Toppers

(C8-C7+(C7>C8))

i.e.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time difference calculation 2
Need help ( Hope i made it clear this time) 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
How to calculate difference between two date & time along with working hours and days 2
formula for adding up 3 different start and finish times 4
Need to work out a timesheet with times going into next day (>24 h 5
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
requie formual based on times. 1

Top