I need formula on how compute the time difference in crystal report??

[peebles1979]

I need help on how to compute the total hours from packing house to start loading time to vessel. Below are the data given:

GroupHeader1 = PackingID
GroupHeader2 = TruckNo

Data:

PH departure = 16:00
Start Loading Time to Vessel = 18:00

What will be the difference from PH Dep to Start Loading??? I need your answer immediately...

 

[pandpp]

Have you tried using the DateDiff function?

Peter.

 

[peebles1979]

Peter, the given data are the following:

PHDep Time = 16:00
Start Time Loading = 20:00

its a 24 hour format or military time

What is the time difference between them? I need formula? DateDiff need a date data. The only given data is time.

 

[pandpp]

The date 01/01/2000 is my personal favourite. Append the time you are given to ANY date, then do a DateDiff.

Couldn't be easier.

Peter.