Time Question/Please Help/Newbie

B

babsanderson

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.
 
J

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.
Click to expand...

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
 
Top