how to convert 0.475 to minutes as 28 mnts. (1 Viewer)

[sreedhar]

how to convert 0.475 to minutes as 28 mnts.

 

[arnelgp]

i assume it is 0.475 of 1 hr.

CInt(0.475*60)

 

[vhung]

Probably;
0.475*60 = 28.5

 

[Uncle Gizmo]

You might find this video on my website useful. It tackles Time from slightly different angle:-

Time & Date - Nifty Access

Time & Date I need this "Dates" page as a general page for the top of my Dates Menu. Will add more information about dates as I find useful stuff on the internet. In the meantime, just below here is a drop down menu which gives you links to the stuff already on my website

www.niftyaccess.com

 

[sreedhar]

how to convert 0.475 to minutes as 28 mnts in access query

 

[Gasman]

how to convert 0.475 to minutes as 28 mnts in access query

Exactly as arnelgp stated?

 

[Pat Hartman]

I suspect you are using a DateTime field to store a duration. As long as the duration doesn't exceed 24 hours you'll be fine. But the DateTime field is intended to show a point in time so once you have more than 24 hours, you end up with days as well so the calculation no longer works. 1.475 * 60 = 88.5 minutes rather than 1468.5.. And if you were to display the value as a date, it would be 12/30/1899 00:28:30.

So, could the duration ever be more than 24 hours?