Crystal Date & Time Function

Yahoo Archive
1
Create a formula "Hours Worked"

(Clock out time) - (Clock in time)

This should give you what you want.

Chris

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Muhammad Sarfaraz
Sent: Monday, October 22, 2007 9:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Date & Time Function.

Is there any Function in Crystal to calculate Time difference likewise
Datedif.
I have 2 times fields ( clock in time) - (Clock out time)
I wanted to calculate how many (hours: min) employee worked .
e.g ( 14:55) - (01:05) = Result should be ( 10:00) hrs.
Time stored in 2400 hrs.
Thanks in advance.

Muhammad Sarfaraz
IT Project Manager
(Vista 8.03.305J - Progress )
Advance Grinding Service, Inc.
Tel: (708) 442 7100 x 313

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com <http://mail.yahoo.com>

[Non-text portions of this message have been removed]
2
Is there any Function in Crystal to calculate Time difference likewise Datedif.
I have 2 times fields ( clock in time) - (Clock out time)
I wanted to calculate how many (hours: min) employee worked .
e.g ( 14:55) - (01:05) = Result should be ( 10:00) hrs.
Time stored in 2400 hrs.
Thanks in advance.


Muhammad Sarfaraz
IT Project Manager
(Vista 8.03.305J - Progress )
Advance Grinding Service, Inc.
Tel: (708) 442 7100 x 313




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]