Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subtraction

Status
Not open for further replies.
Ielamrani

Ielamrani

MIS
Jul 7, 2005
183
US
Hi everyone,
I would like to subtract a text box time from another but I am having trouble..Can anyone help. Thanks in advance

I have 4 text boxes:
Txt1 9:00AM
Txt2 12:00Am

I would like Txt3 to show me 3 (which is Txt1 - Txt2)
 
Sort by date Sort by votes
You might want to look and the DateDiff() function for this.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
 
Upvote 0 Downvote
=Format([Txt2]-[Txt1],"h:nn")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

plcman
  • Locked
  • Question
Imperial Subtraction in Access
Replies
6
Views
55
plcman
plcman
sabloomer
  • Locked
  • Question
Subtraction Function
Replies
6
Views
68
sabloomer
sabloomer
ejc00
  • Locked
  • Question
Strange Addition-Subtraction Result
Replies
2
Views
41
ejc00
ejc00
starmkr1
  • Locked
  • Question
Add and Subtraction in Access
Replies
1
Views
38
BanditWk
BanditWk

Part and Inventory Search

Sponsor

Back
Top