convert minutes to percent of hour

[Guest]

I need to convert minutes to a percent of an hour. For example, 93 hours and
45 minutes (93.45) needs to be converted to 93 hours and 75% of an hour
(93.75).

Can this be done in one step?

 

[Guest]

Are you storing hours and minutes as a decimial number?

I hope you are not trying to add them as the will not.

To convert your 93.45 to hours and percent do this --
Hours: Int([YourField]) & "HRS and " & 60/ ([YourField] -
Int([YourField])) * 100 & "Percent hour"

 

[John Spencer]

One method

Int([SomeValue]) + (([SomeValue] - Int([SomeValue])) /.6)


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Guest]

Already did the calculations in minutes. Thanks, this worked like a charm!

One method

Int([SomeValue]) + (([SomeValue] - Int([SomeValue])) /.6)


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

I need to convert minutes to a percent of an hour. For example, 93 hours and
45 minutes (93.45) needs to be converted to 93 hours and 75% of an hour
(93.75).

Can this be done in one step?