=hour(data)*60+minutes(data)

M

Mektek

I have an excel sheet that uses this calculation. Now I'm tryng to simplify
my work by using access as a tool. I need the formula that would match the
excel.
 
R

raskew via AccessMonster.com

Hi

What exactly are you attempting to arrive at. Please provide an example.

Best Wishes - Bob
 
C

Clifford Bass

Hi,

If you have a date field, you can use essentially the same thing:

Hour(DateField)*60+Minute(DateField)

Note the singular Minute. Date fields also hold time. A time without
a date is actually stored as the zero date in Access (12/30/1899) with the
time component.

Clifford Bass
 
Top