I have 3053 minutes and I want to convert to hours and minutes

  • Thread starter Thread starter John B
  • Start date Start date
J

John B

I am working in Excel 2007 and I have 3053 minutes that is a sum of minutes
and I want to convert to hours and minutes. any suggestions
 
Assuming your data is an actual time format and not just the number 3,053
then you can do that with just a format. Format the number

[h]:mm

If it is just the number then did you want the results converted to time?
Did you want the result as one cell displaying hour and one displaying
minutes?
 
Hi,

try this

=A1/24/60

Format as [h]:mm
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top