time duration

[scott micklo]

Hi Experts

I have a simple code that computes time duration between 2 times in minutes. For example, 10:00 am to 2:00 pm is 240 minutes. And 6:15 pm to 9:15 pm is 180 minutes.

BUT, when I attempt to roll over to the next day ie 10:00 pm to 2:00 am, I keep getting -1200 minutes.

I searched but can not find a quick code that will compute this correctly to 240 minutes.


Here is my code so far:

Please Login or Register  to view this content.

[6StringJazzer]

You have to explicitly calculate the case where it crosses midnight. Here is one way to do it.

BTW you can directly get minutes with "n" instead of getting seconds and dividing by 60.

Please Login or Register  to view this content.

[scott micklo]

Very elegant. Just to ensure I am reading it correctly, you take the "end of the night" and add it to the "begin" of the morning.

Thank you very much

[xladept]

Or, if using minutes:

Please Login or Register  to view this content.