[AccessD] A2K: This should be easy

Arthur Fuller artful at rogers.com
Sun Mar 16 21:17:00 CST 2003


Sunday night and no one's answering so I'll risk a WAG. Subract the number
of seconds for your Time1 to yield Time0. Deal with both times as Longs, do
the subraction there, then format the result back to a time string.


-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Darren Dick
Sent: March 16, 2003 9:46 PM
To: Access Mail Group
Subject: [AccessD] A2K: This should be easy


Hello all
This should be simple.

I have a control on a form (txtStartTime). Formatted for Short time (i.e.
hh:mm)
I want to take say...5, 10 or 15 minutes from whatever time is in
txtStartTime

So take away 15 from 11:00 should give me 10:45

How do I do this.

<Sigh> this should be easy. It probably is, I'm just brain fading.

Darren

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list