convert 2430 minutes to 40 hrs 30 mins

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Min & Hrs to Min in Decimal 6
How to search for the last higher value from a list? 5
How to choose maximum value 7
a twist to relative ranges 5
text to columns 1
Formula to deduct unpaid breaks in time sheet 3
Convert Decimal Minutes to Hours-Minutes-Seconds 3
convert text to number 2

Top