Adding minutes

[Poweruser99]

Hello there.

I have a field of Hours and Minutes. I need to add them to get the total number of hours consumed. The hours fields I can add without any problems.

The minutes field I want to convert to hours. This is what I have

Minutes
-------
60
65

Total of this is 125 which is 2 hours and 5 minutes (2.05)
When I add these two and divide by 60 to get hours I get 2.0833, when I need to get it to 2.05.

Any idea on which formula I can use.

 

[PHV]

A starting point:
(125 \ 60) + (125 MOD 60) / 100

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Poweruser99]

I tired it but no luck. Maybe something wrong with the formula.

 

[PHV]

Any chance you could post what you tried ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886