Change Number field to Time field Question Clarified

[maggiev]

maggiev (MIS) May 8, 2002
To clarify my problem the time field in the DB shows as a a Number.

For example 7:59:11 shows in the DB as 75,911.00 When I turn this number field w/o decimals it shows as 75911.

If the time is 13:06 it shows in the field as 130,621.00 When I turn this to a number w/o decimals is 130621.

This is a time display that shows when the record was originally created.

Thanks for the replies above. I will try some of those formulas.

Thank you,
Maggie

 

[synapsevampire]

I think that someone had given a solution for you there, since it's always either 5 or 6 digits it's very simple, just check for whether it's of length 5 or 6 and parse it.

http://www.informeddatadecisions.com

kai@informeddatadecisions.com