Skip to Content
Oct 16, 2009 at 10:35 AM

Time elapsed between date and time feilds 1 and date and time feilds 2



I'm relatively new to Crystal reports, but have had a little experience with other reporting software in the past.

In a report i'm currently writing I need to have a result of time spent on a visit to a job. In the visits table I have the feilds 'StartedDate' (DD/MM/YYYY hh:mm), 'StartedTime' (hh:mm), 'CompletedDate' (DD/MM/YYYY hh:mm) and 'CompletedTime' (hh:mm) to work with. Unfortunately the 'StartedDate' and 'CompletedDate' feilds have the date info but the time info is all 00:00, hence the database developers have added the further two time feilds.

I was wondering if anyone could suggest a formula that can calculate the time in hours and minutes between the started date/time and the completed date/time - to make it even more complicated the visit might start on day one and finish on day 2, i.e. - Start 01/01/2001 @ 21:00 and End 02/01/2001 @ 05.00.

Hopefully someone can help, It might be quite a simple formula, but as I say i'm quite new to using Crystal and been away from other reporting software for a few years.

Any other info needed, please get in touch.