Is it possible to convert a number into hours and minutes

G

Guest

I calculate a manufacturing process in minutes per unit. The formula gives
the total number of minutes taken - fine until the number of minutes is over
60. Is it possible to convert say 200 minutes to read 3hours and 19 minutes ?
eg 200 divided by 60 = 3.33 and then .33 x 60 to give the number of minutes ?
My thanks in anticipation.
 
G

Guest

Try this:

For minutes in A1

B1: =A1/(24*60)
Format as Time

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
G

Guest

Thank you so much - you know sometimes you try to re-create the world to do
the most simple tasks - this was one of my tasks ! Problem solved - many
thanks again !
 
G

Guest

You are very welcome
--
Gary''s Student


le clef said:
Thank you so much - you know sometimes you try to re-create the world to do
the most simple tasks - this was one of my tasks ! Problem solved - many
thanks again !
Click to expand...
 

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

Converting a number to hours and minutes 4
adding rows of hours and minutes to get a total 1
How do I convert a number of minutes into hours and minutes? 3
how do i convert a column of minutes into hours 2
convert hours and minutes into days 2
converting a number to time 2
How do I convert hours, minutes, and seconds into decimal format? 2
calculating fees from hours and minutes 2

Top