View Single Post
  #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