convert minutes to percent of hour

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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"
 
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
'====================================================
 
Already did the calculations in minutes. Thanks, this worked like a charm!

John Spencer said:
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?
Click to expand...
Click to expand...
 
Back
Top