PC Review


Reply
Thread Tools Rate Thread

change minutes to hours and minutes

 
 
=?Utf-8?B?U3RldmVk?=
Guest
Posts: n/a
 
      6th Jul 2006
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


 
Reply With Quote
 
 
 
 
Biff
Guest
Posts: n/a
 
      6th Jul 2006
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
>
>



 
Reply With Quote
 
=?Utf-8?B?U3RldmVk?=
Guest
Posts: n/a
 
      6th Jul 2006
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
> >
> >

>
>
>

 
Reply With Quote
 
Biff
Guest
Posts: n/a
 
      6th Jul 2006
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
>> >
>> >

>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:43 PM.