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

#### sreedhar

##### New member
how to convert 0.475 to minutes as 28 mnts.

#### arnelgp

##### ..forever waiting... waiting for jellybean!
i assume it is 0.475 of 1 hr.

CInt(0.475*60)

Probably;
0.475*60 = 28.5

#### Uncle Gizmo

##### Nifty Access Guy
Staff member
You might find this video on my website useful. It tackles Time from slightly different angle:-

#### sreedhar

##### New member
how to convert 0.475 to minutes as 28 mnts in access query

#### Gasman

##### Enthusiastic Amateur
how to convert 0.475 to minutes as 28 mnts in access query
Exactly as arnelgp stated?

#### Pat Hartman

##### Super Moderator
Staff member
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?

Replies
10
Views
301
Replies
18
Views
552
Replies
3
Views
155
Replies
22
Views
1,110
Replies
8
Views
519