Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Ms access-how to get the difference between two time fields

2 Posts 2 Posters 0 Views 1 Watching

J Offline
J Offline
jeya krishnan v

wrote on last edited by

#1

We having two fields 1)shift time 2)Actual time .Actually when subtracting these two time we are not able to get in time format for another field.plz give me ur valuable suggestion Jeyan
H 1 Reply Last reply

0
J jeya krishnan v

We having two fields 1)shift time 2)Actual time .Actually when subtracting these two time we are not able to get in time format for another field.plz give me ur valuable suggestion Jeyan
H Offline
H Offline
Hesham Amin

wrote on last edited by

#2

Do you need the difference in hours, minutes or what ? Check :DateDiff Function[^]

Hesham A. Amin blog
1 Reply Last reply

0

Log in to reply