Add up total hours

[Steve]

Hi there,

On the our database we have several date/time boxes which
are filled in a certain stages of a customer order.

Time reported
Time source resolved
Time method requested at source
Time despatch details confirmed
Time rec'd @ company
Time rec'd @ customer

These are all set as General date i.e 20/01/04 08.05

I would like to add the total hours/minutes for each
process
i.e Time reported & Time source resolved etc

Plus I would like to add the total days/hours/minutes for
the complete process

I hope this makes sense. Hope someone can help

cheers Steve

 

[Duane Hookom]

Look at the DateDiff() function in Help.