ExcelBanter - convert 2430 minutes to 40 hrs 30 mins

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - convert 2430 minutes to 40 hrs 30 mins (https://www.excelbanter.com/excel-discussion-misc-queries/157397-convert-2430-minutes-40-hrs-30-mins.html)

vcff

convert 2430 minutes to 40 hrs 30 mins

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.

Mike H

convert 2430 minutes to 40 hrs 30 mins

Use a custom format of

[hh]:mm

in A5

Mike

"vcff" wrote:

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.

vcff

convert 2430 minutes to 40 hrs 30 mins

tnks Mike

r

"Mike H" wrote:

Use a custom format of

[hh]:mm

in A5

Mike

"vcff" wrote:

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.

All times are GMT +1. The time now is 07:40 AM.