Minutes to Hours

D

Diann Savage

I have a worksheet with 12 columns with I totaled in
one column, total minutes. In a separate column I
need to take the total minutes and convert them into
hours and minutes. But with the formula I am using
total minutes/60 it is not calculating correctly. It is
either off by 2 or more minutes. What can I do to
make this total correctly.

My e-mail is [email protected].
 
E

Earl Kiosterud

Diann,

Are these plain numbers representing minutes, or actual time values,
formatted for minutes?
 
Top