I want to calculate time, but still couldn't see the way how to do it. 
Author Message
 I want to calculate time, but still couldn't see the way how to do it.

I want to calculate time, but still couldn't see the way how to do it.
Example :

 If I have the Text or string value 08:00   and 17:30, I want to get the
result of how differ in hours and minutes it is.

Another words, I have to value of Office Hour : 08:00 - 17:30  and Lunch
Hour : 12:00 - 13:00.   I want to calculate total working hours not
including Lunch hour.

Please, help me.   Thanks.



Mon, 19 Jan 2004 11:00:40 GMT  
 I want to calculate time, but still couldn't see the way how to do it.
Check out the DateDiff function.

Quote:
> I want to calculate time, but still couldn't see the way how to do it.
> Example :

>  If I have the Text or string value 08:00   and 17:30, I want to get the
> result of how differ in hours and minutes it is.

> Another words, I have to value of Office Hour : 08:00 - 17:30  and Lunch
> Hour : 12:00 - 13:00.   I want to calculate total working hours not
> including Lunch hour.

> Please, help me.   Thanks.



Mon, 19 Jan 2004 11:23:58 GMT  
 I want to calculate time, but still couldn't see the way how to do it.
Hello,

see the function in VB Help
DateAdd
Best Regards

Quote:
>-----Original Message-----
>I want to calculate time, but still couldn't see the way
how to do it.
>Example :

> If I have the Text or string value 08:00   and 17:30, I
want to get the
>result of how differ in hours and minutes it is.

>Another words, I have to value of Office Hour : 08:00 -
17:30  and Lunch
>Hour : 12:00 - 13:00.   I want to calculate total working
hours not
>including Lunch hour.

>Please, help me.   Thanks.

>.



Tue, 20 Jan 2004 18:44:04 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Run-time Error 3003 Couldn't start transaction

2. Creating time-lapse AVI movie from SNAPPY stills?

3. Some weird run time error I've never seen before

4. ? Internet connection sharing, I've seen this posted several times by people

5. ? Internet connection sharing, I've seen this posted several times by people

6. ? Internet connection sharing, I've seen this posted several times by people

7. ? Internet connection sharing, I've seen this posted several times by people

8. calculate dates calculate time

9. Has anyone seen this done?

10. 'Couldn't find installable ISAM'

11. 'Couldn't find installable ISAM'

12. 'Couldn't find installable ISAM'

 

 
Powered by phpBB® Forum Software