LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
fredmunich
 
Posts: n/a
Default Minutes to Hours:minutes

Hi,

I've been looking, with no success to some post and could not find the
answer. I am sure this has been answered in the past so sorry to ask again.
I have a result in minutes:320 for example
I would like to have the result displayed as 5:20 and not 5.33 (cell/60).
Also, if the number of minutes is greater than 1440 (day) I would like to
have the 2 options:
- hh:mn
- d:hh:mn
In fact I am using both format in 2 reports.
Thanks in advance if you have the solution.
Regards
Fred
 
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
convert hours and minutes to minutes idaho Excel Discussion (Misc queries) 2 January 27th 05 09:45 PM
Adding minutes to time Randberger Excel Discussion (Misc queries) 4 January 19th 05 08:49 PM
convert minutes into hours:minutes tlf713 Excel Worksheet Functions 3 December 15th 04 10:42 PM
How do I convert minutes to hours:minutes? Marc Todd Excel Worksheet Functions 1 November 19th 04 06:27 AM


All times are GMT +1. The time now is 09:13 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"