Formulae for hours calc

BarryStevens

What is a good formulae to use to calculate the number of hours between 2 dates & times.
i.e. date1 is internal date, time1 is internal time - ex time()
date2 is internal date, time2 is internal time - ex time()

hrs = date2+time2 - date1+time1

date1 can be LE date2

DonBakke

I usually convert everything to seconds: (date * 86400) + time. Then just subtract the seconds1 from seconds2 and then divide the difference by 3600 to get hours.

BarryStevens

Thanks

KevinFournier

Also, for those that use SRP Utilities, you can use SRP_Time's HourSpan service.

DonBakke

Will this support a span of more than 24 hours?

KevinFournier

No, but SRP_DateTime HourSpan will.

DonBakke

Nice. Barry would need to convert his date and time to OI internal date time. This looks to be doable using the SRP_DateTime Combine service.

Opto_Will

Is the Combine service because the OI time is 'seconds since midnight' but the OI datetime time component is a 'percentage' of that point in the day? A calulation is therefore required instead of just a concatenation...

KevinFournier

That is correct.

Opto_Will

Perfect.

Another handy SRP tool.