Hi

I am looking to calculate the time difference between a start and an end time. It works ok, but not so much when the times expand over midnight (for example, my start time is 11:30pm, and end time is 12:15am the next day), my length should be 45 minutes but instead is a negative number. Is there a way I can account for this?

I only have the 2 time stamps and did the following define:

Start_time/HHIA =HINPUT(12,'00000000' | FACT_OR.FACT_OR.START_TIME,8,'HHI') ;

End_time/HHIA =HINPUT(12,'00000000' | FACT_OR.FACT_OR.END_TIME,8,'HHI') ;

Length/D12.2 = HDIFF(FACT_OR.FACT_OR.End_time, FACT_OR.FACT_OR.Start_time, 'MINUTE', 'D9');

This message has been edited. Last edited by: <Emily McAllister>,

Does START_TIME not have a date portion?

Hi

I do have a date field that I did not use, but it would only apply to the start date as that date field shows just the date for the start time, I do not have an "end date" field for the end time

Have you searched on "time difference"?

Lot's of posts going way back to 2005 that will give you lot's of ideas and knowledge on how to achieve this.

Good luck

T

quote:

I do not have an "end date" field for the end time

If you don't have the END DATE/TIME how would you know if the end was the next day at 12:30AM or next month? Are there assumptions you can make about how long the difference can be?

Hi,

Yes it is safe to assume none of the times would be beyond the next day for example the next month, all the lengths are within 3-4 hours of each other. So pretty much...this is only applying to anything that was in the late 20s of the 24 hour clock for the start time and then the 0 or 1 hours for the end time

Hi,

Have you tried checking to see if the end time is less than the begin time ? If yes add 1440 minutes to the end time and calculate the difference.