M mr moe Registered User. Local time Today, 07:53 Joined Jul 24, 2003 Messages 332 Sep 23, 2005 #1 I want to do this in either excel or access. for instance I'm trying to add 1 hr to the time I started work. for example if the field is 8:00 Am how do I make it 9:00 AM after adding for example 1. Thanks.
I want to do this in either excel or access. for instance I'm trying to add 1 hr to the time I started work. for example if the field is 8:00 Am how do I make it 9:00 AM after adding for example 1. Thanks.
M modest Registered User. Local time Today, 03:53 Joined Jan 4, 2005 Messages 1,220 Sep 23, 2005 #2 DateAdd("h",1,DateValue(Me.FieldName)) Where Me.FieldName is the name of the field or the date you want to edit. Lookup the DateAdd() function in the help file.
DateAdd("h",1,DateValue(Me.FieldName)) Where Me.FieldName is the name of the field or the date you want to edit. Lookup the DateAdd() function in the help file.
