convert 2430 minutes to 40 hrs 30 mins

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Pls help

I used this formula (=A4/(24*60) in A5 to convert the total minutes to hrs &
mins

A1=400
A2=300
A3=150
A4=850
A5= 14:10

However, if A1=1100, A5=1:50 which is incorrect.
corect answer should be 25:50.
 
tnks Mike

r

Mike H said:
Use a custom format of

[hh]:mm

in A5

Mike

vcff said:
Pls help

I used this formula (=A4/(24*60) in A5 to convert the total minutes to hrs &
mins

A1=400
A2=300
A3=150
A4=850
A5= 14:10

However, if A1=1100, A5=1:50 which is incorrect.
corect answer should be 25:50.
Click to expand...
Click to expand...
 
Back
Top