• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2213
  • Last Modified:

calculate seconds since midnight

how to calculate calculate seconds since midnight?
0
taimur
Asked:
taimur
  • 2
1 Solution
 
rovermCommented:
Use the Timer object. It returns a Single containing the seconds passed since midnight !!!

'Msgbox Timer'

Good luck !

RoverM
0
 
paulstampCommented:
Use DateDiff function, setting the interval as "s"

MsgBox DateDiff("s", "00:00:00", Time)

Cheers.
0
 
paulstampCommented:
The above DateDiff is useful as it can be used to find seconds elapsed since any time or date, in intervals from years down to seconds.
0
 
taimurAuthor Commented:
Just what I needed.

Thank you paulstamp
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now