How to calculate time spent from two dates

[JSeidel]

I am trying to create a "how many minutes field" from two time fields. One being "time start" and the other "time at end" . How do I calculate the "total time from start to end" ?

thanks!

 

[synapsevampire]

Can you supply an example of the format the time is stored in?

Are these datetimes, or?

There's the datediff('n', {MyDatefield1}, {MyDatefield2}) which would return a time difference between two datetime fields, and then there's the Time function, which when subtracted returns time in seconds as in:

((time(DateTime(1996, 1, 1, 12, 10, 10) )-time(DateTime(1996, 1, 1, 12, 9, 10))))/60

returns 1

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[JSeidel]

I can work with either the data model datetime or I also have a time field I got from separating the data model datetime

 

[synapsevampire]

Create a formula and use either of the above methods, the first being the simplest.

datediff('n', {MyDatefield1}, {MyDatefield2})

The 'n' designates minutes.



-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com