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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time calculation

Status
Not open for further replies.
nkamp

nkamp

Programmer
Jan 19, 2004
35
0
0
NL
Hello,

I want at some stage everytime look back for half an hour like:

Datediff("s", Timvalue(Time)-Timevalue("00:30:00"), rec("par1").value)

Is there in VBA a simple function for?

thanks in advance!

Nico
 
Sort by date Sort by votes
DateAdd should suit, for example:

[tt]DateAdd("n", -30, #6:57:58#)[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Aurillius
  • Locked
  • Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
174
Andrzejek
Andrzejek
EM1107
  • Locked
  • Question
calculated time difference. 1
Replies
2
Views
130
strongm
strongm
nikademous
  • Locked
  • Question
Run Time Error 6 Overflow
Replies
4
Views
69
strongm
strongm
Abakurd
  • Locked
  • Question
Read or set time automatically in windows 10
Replies
1
Views
61
strongm
strongm
olushow
  • Locked
  • Question
Run Time Error '3464'
Replies
1
Views
51
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top