Time Calculations

[Guest]

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.

 

[Rick Brandt]

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.

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

 

[Guest]

This works great.

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