Time Question/Please Help/Newbie

[Guest]

I have a field with start time (ex. 0900). I have an amount of hours
(ex.4.625 hours) I want to have a field that fills in the time out by
adding the 4.625 hours to the start time of 0900. I just can't get it.

 

[John Vinson]

I have a field with start time (ex. 0900). I have an amount of hours
(ex.4.625 hours) I want to have a field that fills in the time out by
adding the 4.625 hours to the start time of 0900. I just can't get it.

An Access Date/Time field is stored as a Double Float number, a count
of days and fractions of a day (times). You should be able to use an
expression like

DateValue([Start Time] + (4.625 / 24))

to get the result you want.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps