Time Calculations

G

Greg

I'd like the determine how many minutes into the day for a given date/time
variable. In other words, the value of 04/25/2007 02:00:00 AM would return
120 minutes, which is 2 hours into the day. Any ideas on how I can achieve
this using a function?

Thanks.
 
R

Rick Brandt

Greg said:
I'd like the determine how many minutes into the day for a given
date/time variable. In other words, the value of 04/25/2007 02:00:00
AM would return 120 minutes, which is 2 hours into the day. Any ideas
on how I can achieve this using a function?

Thanks.
Click to expand...

=DateDiff("n", Date(), Now())
 
Top