Calculate time - between start date and end date

HCL Domino Domino Forum
1

i have two fields, i want to calculate the time difference in days, hours, minutes, seconds between these two date fields.

any help appreciated…

2

Subject: Calculate time - between start date and end date

If you mean you need to display something like ‘10 days, 13 hours…’, you’ll need to subtract the times (give you seconds between) then do the math and build a string with the results.

If that’s not what you mean, what do you mean (give an example maybe?)

3

Subject: Calculate time - between start date and end date

Use the help files then :stuck_out_tongue:

4

Subject: RE: Calculate time - between start date and end date

First field is start date .date and time recorded in this field.second field is end date. date and time recorded in this field.

i need to calculate how long between both dates.

eg 2 days, 10 hours, 1 minute…thanks appreciate your help.

5

Subject: RE: Calculate time - between start date and end date

Looks like this has popped up before:

http://www-10.lotus.com/ldd/nd6forum.nsf/Search?SearchView&Query=hours%20and%20minutes%20and%20seconds&SearchOrder=0&Start=1&Count=100

And the more general problem of converting seconds into d:h:m:s

http://www.google.com/search?q=convert+seconds+into+hours+minutes+seconds

HTH

doug

6

Subject: RE: Calculate time - between start date and end date

Doug

thanks for your help. loads of ideas to get me started. thanks