G giorgio Mar 18, 2004 #1 How can i convert e field time [hours.minute.seconds] in only minute for use it a query ?
M MGFoster Mar 18, 2004 #2 giorgio said: How can i convert e field time [hours.minute.seconds] in only minute for use it a query ? Click to expand... Minute("18:30:45") = 30
giorgio said: How can i convert e field time [hours.minute.seconds] in only minute for use it a query ? Click to expand... Minute("18:30:45") = 30
J John Vinson Mar 18, 2004 #3 How can i convert e field time [hours.minute.seconds] in only minute for use it a query ? Click to expand... If you want 1:15:30 to be converted to 15, use the Minute() function. If you want it to convert to 75.5, use: 1440*CDbl([timefield]) Access stores dates as days and fractions of a day, and there are 1440 minutes in a day.
How can i convert e field time [hours.minute.seconds] in only minute for use it a query ? Click to expand... If you want 1:15:30 to be converted to 15, use the Minute() function. If you want it to convert to 75.5, use: 1440*CDbl([timefield]) Access stores dates as days and fractions of a day, and there are 1440 minutes in a day.
