Fred,
Divide by 1440 and format as time
=A1/1440
--
HTH
RP
(remove nothere from the email address if mailing direct)
"fredmunich" wrote in message
...
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
|