Help with converting time values

[BCarruth]

I have a calculated time value and would like to see it in decimal values for example:
Time value is 5:27 I would like to see the decimal value of 5.45 (I got these values using Excel formulas, but I can't get it to work in Access)

 

[PaulBricker]

To get the decimal value for minutes, you divide the minutes by 60. You can generally extract specific parts of a date/time field using the DatePart() function. DatePart("n",[TimeField])/60 will give you the minutes as a decimal.

Paul

 

[BCarruth]

Thanks for the answer that solved my problem

Bob