Convert Total minutes into hours

[Portuga]

Hello,

I have in Column A the total number of minutes:
Cell A1=42
Cell A2=219
Cell A3=3952
Cell A4=62

In Column B I want to have the total amount of hours:
B1= 00:42
B2=etc
B3=etc
B4=etc

Anyone? Thank

 

[Frank Kabel]

Hi
enter the following formula in B1
=A1/(24*60)
and format this cell as time
copy down for all rows

 

[sen_edp]

hello

i think this formula works fine

e.g. you have 180 in A1

then in B1 enter

=text(a1/1440,"hh:mm")


ht

 

[Guest]

H
EIther works, but Franks results can be used in calculations, the other can't. Be sure to format the cells as Time
Regards

 

[Paul]

Hi guys,

=A1/(60*24) then (custom) format cells [hh]:mm
This will ensure hours greater than 24 will be displayed.
Also format any totalling cell likewise.

If you just use the normal time format hh:mm
times greater than 1440 mins will not display properly.

mins hh:mm [hh]:mm
1440 00:00 24:00
2880 00:00 48:00
3952 (2 days)17:52 65:52


Regards

Paul