convert 2430 minutes to 40 hrs 30 mins

's Computer Specifications

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.

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert minutes to hours and mins	Danie	Microsoft Access	5	25th Sep 2009 10:28 PM
how can i convert a value quoted in hrs,mins,secs to just mins	=?Utf-8?B?VGhlIG1hbiBmcm9tIGRlbG1vbnRl?=	Microsoft Excel Worksheet Functions	1	17th Oct 2006 11:12 AM
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins?	StargateFan	Microsoft Excel Misc	8	7th Jan 2006 07:35 PM
How do I convert hours and mins into just minutes in excel?	=?Utf-8?B?SnNtaXRoNTY2Mw==?=	Microsoft Excel Worksheet Functions	1	17th Nov 2005 04:57 PM
How to convert numeric value to mins and addimg mins to Hrs.	ramana	Microsoft Excel Worksheet Functions	1	28th Oct 2005 10:42 AM