Hi all I just got struck in calculating the time from the date/time field.I am creating a report which will export the data to excel in which i need to do the following-
1)I am having two datetime fields-assigned,closed
2)i need the time difference by deducting the field
closed-assigned
then i need to print the report
<=30 mins then the total assignments
Between 30 minsto 60 mins then the total assignments
Between 1 hrs mins to 4 hrs then the total assignments
Regards
Dali
Subject: Calculating Time from Date/Time Field
time difference is in seconds. So to get minutes, just divide by 60, then use your normal rules for less than 30 minutes, etc.
I’m not sure I understand what you mean “<=30 mins then the total assignments” - explain a bit more.
Subject: RE: Calculating Time from Date/Time Field
I need to show the resolution time ,so here <= 30 mins is for showing the documents which are having theresolution time <=30.
how i will calculate the time from the date time field using lotus script,plz explain me.
I need closed-assigned in time format then i need to put the data in report using mins and hours format.
Subject: RE: Calculating Time from Date/Time Field
What is “resolution time” - is that the difference between closed and assigned?
If that is so, then create a new hidden field (call it timediff), computed, to subtract closed from assigned and divide by 60. Then you can simply put the documents in a view with the first categorized column being a formula based on timediff, something like this …
@If(timediff<30;“AAA”;timediff>30 & timediff<=240;“BBB”;“CCC”)
Make sure the Select formul for the view only accepts documents with a valid timediff field.