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

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
 
J

Jim Thomlinson

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?
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concerting total minutes to hours and minutes 7
Convert Minutes into Hours and Minutes 5
Help with time formatting 2
CONVERT HOURS AND MINUTES TO INT 3
Need to convert hours and minutes to hours and tenths. 2
I need to convert 157.25 minutes, into hours, minutes and seconds. 1
dividing a number into hours and minutes 1
Working with duration data 3

Top