| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time differences across two (or more) dates | Excel Discussion (Misc queries) | |||
| Hot key for time? | New Users to Excel | |||
| Hot key for time? | Excel Worksheet Functions | |||
| Hot key for time? | Excel Discussion (Misc queries) | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
Linear Mode
