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

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

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