Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Erwin
 
Posts: n/a
Default how to change a decimal number (minutes) into hours and minutes?

Greetings,

I'm trying to convert a number (which represents minutes, e.g. 156) into an
hour and minutes format. The result would be 2:36.
Anybody knows how to do this?

Thanks a lot,
Erwin
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default how to change a decimal number (minutes) into hours and minutes?

Try this:
If your minutes value is in A1
=A1/(24*60)

Note: (24hours in a day*60minutes per hour)

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Erwin" wrote:

Greetings,

I'm trying to convert a number (which represents minutes, e.g. 156) into an
hour and minutes format. The result would be 2:36.
Anybody knows how to do this?

Thanks a lot,
Erwin

  #3   Report Post  
Erwin
 
Posts: n/a
Default how to change a decimal number (minutes) into hours and minute

Dear Ron,

Thanks a lot, this is what I want.
I was looking for formulas and complicated calculations ..... this solution
is so easy ..... shame on me!!!

Kind regards,
Erwin

"Ron Coderre" wrote:

Try this:
If your minutes value is in A1
=A1/(24*60)

Note: (24hours in a day*60minutes per hour)

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Erwin" wrote:

Greetings,

I'm trying to convert a number (which represents minutes, e.g. 156) into an
hour and minutes format. The result would be 2:36.
Anybody knows how to do this?

Thanks a lot,
Erwin

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
Adding hours and minutes Patrick Excel Worksheet Functions 16 June 18th 08 09:24 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
how to convert total hours (HH:MM) into decimal number Greg T Excel Worksheet Functions 1 November 17th 04 04:07 PM


All times are GMT +1. The time now is 04:53 PM.

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"