Importing from Excel

[tarena]

I have a report run from one program and it lists times that employees clock in and out. It gives me all the info I need but it lists all of it in columns. I need to import this into a table and calculate it as follows. (TIME IN minus TIME OUT)minus (LUNCH IN minus LUNCH OUT). How can I do this? Can I do this?

Thanks again
Tarena

 

[SkipVought]

Hi,

Sure! What have you tried so far?

Skip,

_[red][/red]

 

[PHV]

Import into a table and then use a query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tarena]

Hey Skip,
I imported the data into a table, used a query to seperate the "ins" from the "outs" and now I need to calculate these but I can't bring them together to do this.

 

[SkipVought]

ABS(IN minus OUT) is elapsed Date/Time

Skip,

_[red][/red]

 

[tarena]

Alright Skip, I'm obviously a dummy here...what does that mean?

Thanks

 

[SkipVought]

The Absolute difference between the IN Date/Time and the OUT Date/Time is the ELAPSED Time.

Skip,

_[red][/red]

 

[SkipVought]

...or you could say, more generally, the absolute difference between any two Date/Time values, is the Elapsed Time in that defined interval.

Skip,

_[red][/red]

 

[SkipVought]

...forthermore, the UNITS of the Elapsed Time, is DAYS, where any fractional part of a day, can be expressed in houes, minutes and seconds.

In fact, ANY Date/Time value, can be expressed in ANY Date/Time UNIT: Millenia, Centuries, Years, Months (somewhat tricky), Fortnights, Weeks, Days, Hours, Minutes, Seconds.


Skip,

_[red][/red]

 

[tarena]

Alright, how do i do this????

 

[PHV]

What have you as input data and which code have you tried ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886