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

  • Thread starter Thread starter Mektek
  • Start date Start date
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.
 
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
 
Back
Top