georgereni
IS-IT--Management
georgereni (IS/IT--Manageme) Jun 21, 2004
to all who can help:
I am exporting a report from our internal reporting server that has information in a time format for each employee.
Example:
LastName, FirstName, Login Time
Smith John 3305:31:40
Which means that John Smith has been logged in for Three Thousand five hours, thirty one minutes and forty seconds.
When I import the data into an access table, it records the time as date and time, and messes the numbers up.
it will show that John Smith's login time as: 4/19/1900 5:00pm, or when I change the setting in the design view to short time it will change the record to 4/19/1900 2:40 am.
How do I get the table to show that the data is hours or total mins calculated and not time?
to all who can help:
I am exporting a report from our internal reporting server that has information in a time format for each employee.
Example:
LastName, FirstName, Login Time
Smith John 3305:31:40
Which means that John Smith has been logged in for Three Thousand five hours, thirty one minutes and forty seconds.
When I import the data into an access table, it records the time as date and time, and messes the numbers up.
it will show that John Smith's login time as: 4/19/1900 5:00pm, or when I change the setting in the design view to short time it will change the record to 4/19/1900 2:40 am.
How do I get the table to show that the data is hours or total mins calculated and not time?