date time field in minutes.

[jobillborf]

elapsed time in minutes.

I have two datetime fields one startdate the other enddate. What would be the formula for the amount of time in minutes.

elapsed time in hours and minutes.

and elapsed time in days, hours and minutes.


thank you

 

[bdreed35]

Take a look at this FAQ faq767-3543. It should get you on the right track.

~Brian

 

[synapsevampire]

Not sure why Brian's link didn't create a hyperlink to my FAQ, I'll try:

faq767-3543

This shows seconds to HH:MM:SS

To obtain the seconds between 2 dates use:

datediff("s",start,end)

-k