change minutes to hours and minutes

's Computer Specifications

Hello from Steved

I have a total off 1350 minutes and take away 30 minutes for the meal break.

What formula could I use please to get the result above. ( Hours and minutes )

Thankyou

's Computer Specifications

Divide by 1440 and format as h:mm

=1350/1440 = 0.9375

Formatted as h:mm = 22:30

Biff

"Steved" <(E-Mail Removed)> wrote in message
news:818C461A-5F01-4789-AC6B-(E-Mail Removed)...
> Hello from Steved
>
> I have a total off 1350 minutes and take away 30 minutes for the meal
> break.
>
> What formula could I use please to get the result above. ( Hours and
> minutes )
>
> Thankyou
>
>

's Computer Specifications

Thanks Biff

"Biff" wrote:

> Divide by 1440 and format as h:mm
>
> =1350/1440 = 0.9375
>
> Formatted as h:mm = 22:30
>
> Biff
>
> "Steved" <(E-Mail Removed)> wrote in message
> news:818C461A-5F01-4789-AC6B-(E-Mail Removed)...
> > Hello from Steved
> >
> > I have a total off 1350 minutes and take away 30 minutes for the meal
> > break.
> >
> > What formula could I use please to get the result above. ( Hours and
> > minutes )
> >
> > Thankyou
> >
> >
>
>
>

's Computer Specifications

You're welcome!

Biff

"Steved" <(E-Mail Removed)> wrote in message
news:B2D1491F-15DB-404E-B028-(E-Mail Removed)...
> Thanks Biff
>
> "Biff" wrote:
>
>> Divide by 1440 and format as h:mm
>>
>> =1350/1440 = 0.9375
>>
>> Formatted as h:mm = 22:30
>>
>> Biff
>>
>> "Steved" <(E-Mail Removed)> wrote in message
>> news:818C461A-5F01-4789-AC6B-(E-Mail Removed)...
>> > Hello from Steved
>> >
>> > I have a total off 1350 minutes and take away 30 minutes for the meal
>> > break.
>> >
>> > What formula could I use please to get the result above. ( Hours and
>> > minutes )
>> >
>> > Thankyou
>> >
>> >
>>
>>
>>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Decimal Minutes to Hours-Minutes-Seconds	Scott	Microsoft Excel Programming	3	22nd Oct 2008 03:26 AM
converting Days Hours & minutes into just minutes in excel	=?Utf-8?B?U2l4IFNpZ21hIEJsYWNrYmVsdA==?=	Microsoft Excel Misc	5	28th Apr 2006 09:45 PM
Display Total Minutes in Days:Hours:Minutes	=?Utf-8?B?Y2JqYW1lcw==?=	Microsoft Access	5	16th Jan 2006 04:15 PM
how to change a decimal number (minutes) into hours and minutes?	=?Utf-8?B?RXJ3aW4=?=	Microsoft Excel Misc	2	5th Nov 2005 04:22 PM
MOD Function or how to convert total minutes to hours and minutes	Brad	Microsoft Access Reports	1	22nd Dec 2004 08:07 AM