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

 

[Guest]

-----Original Message-----

Thanks for the swift reply, I have tried it but i get an
error message of Undefined function 'FormatNumber' in
expression.

Any more help would be greatly appricieated

Thanks Steve

Hi Steve,

I have a similar calculation. I have a table that has

an 'HoursWorked' field. Then I run an updateQuery with
the following in the 'Update to' row:

FormatNumber(DateDiff("n",[ActivityStartTime], [ActivityEndTime])/60,1)

After the update the HoursWorked has a value similar to "6.1" or "8.5"

Hope this helps.

Rick...
----- Steve wrote: -----

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

.

 

[Guest]

Steve

One, I'm a new user like you so I'm not sure that I gave you the best advice, I was sharing what worked for me
Two, type 'FormatNumber' in the 'Wizard Build Expressions' window, select the word and press 'help'. You get the MS details on the function
Three, most pros will tell you NOT to have a table that has a calculated field. You can display the calculation on a form or a report. The method I shared does update the table because I thought that the form required the info (wrong, I'm changing it now..
Four, look up 'DateDiff' too

Rick..

----- (e-mail address removed) wrote: ----

-----Original Message----

Thanks for the swift reply, I have tried it but i get an
error message of Undefined function 'FormatNumber' in
expression

Any more help would be greatly appricieate

Thanks Stev

Hi Steve

an 'HoursWorked' field. Then I run an updateQuery with
the following in the 'Update to' row

FormatNumber(DateDiff("n",[ActivityStartTime] [ActivityEndTime])/60,1

After the update the HoursWorked has a value similar to "6.1" or "8.5
Hope this helps
Rick.. ----- Steve wrote: ----
Hi there
On the our database we have several date/time boxes

which
are filled in a certain stages of a customer order

Time reporte

Time source resolve
Time method requested at sourc
Time despatch details confirme
Time rec'd @ compan
Time rec'd @ custome

These are all set as General date i.e 20/01/04 08.0
I would like to add the total hours/minutes for

each
proces
i.e Time reported & Time source resolved et

Plus I would like to add the total

days/hours/minutes for
the complete proces

I hope this makes sense. Hope someone can hel
cheers Stev