dbTalk Databases Forums  

subtacting times in Access

comp.database.ms-access comp.database.ms-access


Discuss subtacting times in Access in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rschoenert@earthlink.net
 
Posts: n/a

Default subtacting times in Access - 10-29-2006 , 12:29 AM






Does anyone know how to subtract time and place the answer into
another field in MS Access?
for example the fields are:
Start is text hr.mn where hr is Hour and mn in minutes, all text
Finish is text hr.nm where hr is hour and nm in minutes, all text

start could be late one day and finish could be early the next day.
example: start = 11.00 and finish = 01.00
total time then would be 2 hours and field three would be 2.0 (hours
and tenths of hours)

thanks

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.