Difference between initial time and final time code not working correcly!

I am writing VBA code to calculate the difference between initial time and final time. It works until the time span moves to 13 hours. My application is to calculate the difference between two times. I will never have a value that goes over 24hrs. It works when I give it the following values: Initial 6hr, 30min, AM, Final 11hr, 30min, AM. - I get the value 5hr 0min -correct! The following values do not work: Initial 6hr, 30min, AM, Final 7hr, 30min, FM - I should get 13hr, 0min; however it gives me 1hr, 0min -incorrect!
Anybody have any idea why it is not calculating correctly? Thanks
redsab

Thanks JBeaucaire,

That works great! Sometimes I wonder if I can be a programmer when I see some of the coding on this web site! I have not totally figured out your coding, but I will study it. My next phase, is to return a result of 23 hours when I have the following input Initial hour 6:00AM all the way back around to Final hour 5:00AM, which should yield 23 hours. I will see if I can incorporate some of your fancy footwork in my coding!! Thank you very much!
redsab

Short version, works till 23:59

Please Login or Register  to view this content.

Kind regards
Leo

LeoTaxi,

That works great! Small little program. I'm still trying to understand it! Thank you.
redsab

JBeaucaire, what hat do you pull these formulas from. My attempt at it was a lot more coding, so I'm not going to reinvent the wheel! So if

Please Login or Register  to view this content.

evaluates TRUE then you subtract a 1? What does that do?
Thanks,
redsab

Thanks JBeaucaire, that is clever!
redsab