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
|