Originally Posted by
gh1253
Long time since I've worked in Access much less 2013 version. Have table with individual time in and individual time out in hh:mm format. Calculate difference between time in and time out with resulting time in hh:mm format. Want to convert this result to hh.h.
Thanks for any assistance.
You'll need to do some arithmetic.
I'm doing this freehand, so forgive any issues...
Code:
dim outTime as string
dim varTime as variant
vartime=now()
outtime = hour(vartime) & "." minute(vartime)\6
msgbox vartime & vbcrlf & outtime