I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

=A1/24/60
Format cell as h:mm

"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

Wow that was easy. Thank you so much.

"Teethless mama" wrote:

=A1/24/60
Format cell as h:mm

"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

Try one of these:

To convert the values in place:

Enter 1440 in some empty cell
Now, copy that cell, Goto EditCopy
Select the values to convert
Goto EditPaste SpecialDivideOK
Format the cells as [h]:mm

Or:

A1 = 127

=A1/1440

Format as [h]:mm

Biff

"Colette" wrote in message
...
I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total
minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

Thank you so much. It works.

"T. Valko" wrote:

Try one of these:

To convert the values in place:

Enter 1440 in some empty cell
Now, copy that cell, Goto EditCopy
Select the values to convert
Goto EditPaste SpecialDivideOK
Format the cells as [h]:mm

Or:

A1 = 127

=A1/1440

Format as [h]:mm

Biff

"Colette" wrote in message
...
I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total
minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

You're welcome!

Biff

"Colette" wrote in message
...
Thank you so much. It works.

"T. Valko" wrote:

Try one of these:

To convert the values in place:

Enter 1440 in some empty cell
Now, copy that cell, Goto EditCopy
Select the values to convert
Goto EditPaste SpecialDivideOK
Format the cells as [h]:mm

Or:

A1 = 127

=A1/1440

Format as [h]:mm

Biff

"Colette" wrote in message
...
I have a project which only gives me minutes. I need to convert the
total
minutes to hours and minutes. Example: 127 is the number (total
minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to
look
like this 2:07

If the hours will be less than 24 then use 127/60 and format the cell as time
using 24 hour clock.

If the hours will be 24 or greater use =int(127/60)&":"&text(mod(127,60),"00")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

No, Martin. Excel's times are in days, not hours. Colette will need to
divide by 24, as well as by 60. Your formula will give 2:48 (having lost
the odd 2 days), rather than 2:07.
--
David Biddulph

"Martin Fishlock" wrote in message
...
If the hours will be less than 24 then use 127/60 and format the cell as
time
using 24 hour clock.
....
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

"Colette" wrote:

I have a project which only gives me minutes. I need to convert the
total
minutes to hours and minutes. Example: 127 is the number (total
minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to
look
like this 2:07

On 22 Dec 2006, 11:43, "David Biddulph"
wrote:
No, Martin. Excel'stimes are in days, nothours. Colette will need to
divide by 24, as well as by 60. Your formula will give 2:48 (having lost
the odd 2 days), rather than 2:07.
--
David Biddulph

"Martin Fishlock" wrote in message

...



If thehourswill be less than 24 then use 127/60 and format the cell as
time
using 24 hour clock.
...
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"Colette" wrote:

I have a project which only gives meminutes. I need to convert the
total
minutestohoursandminutes. Example: 127 is the number (total
minutes).
I need it to read it took 2hoursand 7minutesto complete. Needs to
look
like this 2:07- Hide quoted text -

- Show quoted text -

Genius! i found that very useful too!

Cheers

chetz

In addition to Dave's comments, if hours are greater than 24, you can easily
display them using a custom format of [h]:mm.

--
Regards,
Fred


"Martin Fishlock" wrote in message
...
If the hours will be less than 24 then use 127/60 and format the cell as time
using 24 hour clock.

If the hours will be 24 or greater use =int(127/60)&":"&text(mod(127,60),"00")
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07

"Colette" wrote:

I have a project which only gives me minutes. I need to convert the total
minutes to hours and minutes. Example: 127 is the number (total minutes).
I need it to read it took 2 hours and 7 minutes to complete. Needs to look
like this 2:07