BusinessObjects Board

Calculating duration in minutes between two date time stamps

I am trying to figure out a way to calculate the duration of time in minutes between two date and time stamps. My date and time stamp are in the format of:

01/09/2008 09:36:50 AM

So for example if my start time is 01/09/2008 09:36:50 AM and end time is 01/10/2008 09:36:50 AM it will return 1440

Any help in this matter would be great. I am using BusinessObjects Enterprise XI Release 2 Infoview

rlugones (BOB member since 2009-02-14)

Welcome to B:bob:B!

Have a look at this post where the same problem was discussed. It’s for DeskI but should not be a problem to change the formula to use WebI functions:

Marek Chladny :slovakia: (BOB member since 2003-11-27)