Hello Listers
I know its Friday but I have a question regarding calculating the time in a
Remedy Form. I have 2 Date/Time fields on a form in which I need to figure
out how to determine the time difference from Field A Field B in total
time but the format I need the result in is hours and
b - a = c
c is seconds
c mod 60 = seconds
c / 60 = minutes with a remainder in seconds
c / 3600 = hours with a remainder in seconds
drop the remainder for minutes and hours, then you can create a
string with the format of hours:minutes:seconds
Axton Grams
On Fri, Jun 27, 2008 at 10:18 AM,
, and you're
done.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Abdul Baytops
Sent: Friday, June 27, 2008 9:19 AM
To: arslist@ARSLIST.ORG
Subject: Calculating Time
**
Hello Listers
I know its Friday but I have a question
: Friday, June 27, 2008 8:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: Calculating Time
b - a = c
c is seconds
c mod 60 = seconds
c / 60 = minutes with a remainder in seconds c / 3600 = hours with a
remainder in seconds
drop the remainder for minutes and hours, then you can create a string
)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Friday, June 27, 2008 10:50 AM
To: arslist@ARSLIST.ORG
Subject: Re: Calculating Time
And if they are in fact date/time fields...and you have the possibility of
more than 24 hours...you might want to add another for 'days'...and limit
hours
Abdul,
Perhaps a look at one of the educational viewlets here will help?
http://www.buoyantsolutions.net/ARS_Education.html
Take a look at the one about calculating time (Manipulating Dates).
Hope this helps.
Regards...Gidd
-Original Message-
From: Action Request System discussion list
6 matches
Mail list logo
