Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
le clef
 
Posts: n/a
Default Is it possible to convert a number into hours and minutes

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Is it possible to convert a number into hours and minutes

Yes:

=A1/24/60

and format the cell as hh:mm
--
Gary''s Student


"le clef" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Is it possible to convert a number into hours and minutes

Try this:

For minutes in A1

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

Does that help?

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

XL2002, WinXP-Pro


"le clef" wrote:

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.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
le clef
 
Posts: n/a
Default Is it possible to convert a number into hours and minutes

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 !

"Gary''s Student" wrote:

Yes:

=A1/24/60

and format the cell as hh:mm
--
Gary''s Student


"le clef" wrote:

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.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Is it possible to convert a number into hours and minutes

You are very welcome
--
Gary''s Student


"le clef" wrote:

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 !

"Gary''s Student" wrote:

Yes:

=A1/24/60

and format the cell as hh:mm
--
Gary''s Student


"le clef" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to convert hours and minutes to hours and tenths. MikeC Excel Discussion (Misc queries) 2 February 9th 06 07:22 PM
How to convert minutes to fractional hours Elara Excel Worksheet Functions 4 November 18th 05 11:30 PM
adding rows of hours and minutes to get a total Tipps Excel Worksheet Functions 1 November 4th 05 08:03 PM
How do I convert a number of minutes into hours and minutes? gyrkin Excel Worksheet Functions 3 August 18th 05 11:12 PM
Convert a number of minutes like 400 into hours and minutes bloke Excel Worksheet Functions 3 June 24th 05 05:00 PM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"