Total hours

[Steve]

Hi I posted this earlier but still seem to have the
problem of seeing 'message unavalable' when i look at the
responces, if someone could email me a solution i would
be very grateful, or email me why i get this error
message on the newsgroup

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

 

[John Vinson]

Microsoft's website is apparently not working correctly: messages
posted from NNTP servers (such as mine) aren't becoming visible. They
can be seen if you use Usenet rather than the website - that is, set
Outlook Express or another newsreader to point to msnews.microsoft.com
as a news server.

I'm copying my previous response to EMail. Please reply to the
newsgroup if you can use NNTP; otherwise I'll make an exception and
accept email reply for the duration of this out(r)age.

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

The DateDiff() function calculates the difference in time between
date/time field values - DateDiff("n", [Time Reported], [Time Source
Resolved]) would give the difference in minutes, divide by 60 to get
hours. These values can be summed... but DON'T try to store the time
duration in a Date/Time field, which is best reserved for exact points
in time. Instead, sum minutes and divide by 60 to get fractional
hours. There are also expressions to convert 334 minutes to 5:34 if
you prefer that display:

[duration] \ 60 & Format([duration] MOD 60, ":00")

for instance.

 

[Steve]

Thanks for the help John I will give it a try. Also thanks for the info
about outlook

cheers Steve

Microsoft's website is apparently not working correctly: messages
posted from NNTP servers (such as mine) aren't becoming visible. They
can be seen if you use Usenet rather than the website - that is, set
Outlook Express or another newsreader to point to msnews.microsoft.com
as a news server.

I'm copying my previous response to EMail. Please reply to the
newsgroup if you can use NNTP; otherwise I'll make an exception and
accept email reply for the duration of this out(r)age.

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

The DateDiff() function calculates the difference in time between
date/time field values - DateDiff("n", [Time Reported], [Time Source
Resolved]) would give the difference in minutes, divide by 60 to get
hours. These values can be summed... but DON'T try to store the time
duration in a Date/Time field, which is best reserved for exact points
in time. Instead, sum minutes and divide by 60 to get fractional
hours. There are also expressions to convert 334 minutes to 5:34 if
you prefer that display:

[duration] \ 60 & Format([duration] MOD 60, ":00")

for instance.