Convert Total minutes into hours

P

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
 
F

Frank Kabel

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

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
 
S

Steve

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

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
 
Top