Minutes to Hours

  • Thread starter Thread starter Diann Savage
  • Start date Start date
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 (e-mail address removed).
 
Diann,

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