simplest possible way to calculate the number of total minutes spent

[montubhardwaj]

Hi All,

I have two Date columns with Timestamp as below

Start_Date:  6/6/2011 11:49:42 PM

End_Date:    6/7/2011 12:10:42 AM

I want the simplest possible way to calculate the number of total minutes spent on the activity.

[dpietersz · Accepted solution]

Hi Sharma,

I made a small example for you.

I think this is what you are looking for.

[#3]

Try this:

To find minutes:

Minute(Num(End_Date)-Num(Start_Date))

To find Hours:

Hour(Num(End_Date)-Num(Start_Date))

But the approach of diepterz is more nice.....

[montubhardwaj]

Hi Dimitri,

This works like charm... many thanks. Thanks Erika