Re: HOURS function doesnt appear to work correctly-CLOSED

2011-04-01 Thread Matthew Perrault
I did just do the math myself and it worked fine. ((Date_Time1 - Date_Time2) - (Days * 86400)) /60 /60 My concern was that HOURS() worked differently than MINUTES() or SECONDS() Which worked as I expected. The results and how they worked is inconsistent, which was why I posed the question.

Re: HOURS function doesnt appear to work correctly-CLOSED

2011-04-01 Thread Misi Mladoniczky
Hi, No, it is not inconsistent. Seconds are seconds regardless of date, your timezone, daylighsavingstime, etc. Hours depend on all these things. The date is stored as the number of seconds since 1970-01-01 00:00:00 GMT. By doing the math (Date_Time1 - Date_Time2), you revert to 1970-01-01,

Re: HOURS function doesnt appear to work correctly-CLOSED

2011-04-01 Thread Matthew Perrault
to help. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Friday, April 01, 2011 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: HOURS function doesnt appear to work correctly-CLOSED Hi

Re: HOURS function doesnt appear to work correctly-CLOSED

2011-04-01 Thread Misi Mladoniczky
. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Friday, April 01, 2011 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: HOURS function doesnt appear to work correctly-CLOSED Hi, No, it is not inconsistent