Time Calculations

[Guest]

Hi

I have a table with a “down time†and an “up time†field. I would like to
get the total number of minutes between the two. The time difference may be
as long as 16 hours but I want it to display just in total minutes.

Thanks in advance for any help with this.

Chuck

 

[Rick B]

=(DateDiff("n",[Down Time],[Up Time]))

 

[Rick Brandt]

Hi

I have a table with a "down time" and an "up time" field. I would
like to get the total number of minutes between the two. The time
difference may be as long as 16 hours but I want it to display just
in total minutes.

Thanks in advance for any help with this.

Chuck

=DateDiff("n", [down time], [up time])

 

[Rick B]

The extra set of parenthesis is not needed. I copied this from a more
elaborate field.

=DateDiff("n",[Down Time],[Up Time])


--
Rick B

=(DateDiff("n",[Down Time],[Up Time]))
--
Rick B

Hi

I have a table with a "down time" and an "up time" field. I would like to
get the total number of minutes between the two. The time difference may
be
as long as 16 hours but I want it to display just in total minutes.

Thanks in advance for any help with this.

Chuck

 

[Guest]

Thanks ! that does exactly what I need.