change minutes to hours and minutes

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

Divide by 1440 and format as h:mm

=1350/1440 = 0.9375

Formatted as h:mm = 22:30

Biff

"Steved" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Thanks Biff

"Biff" wrote:

> Divide by 1440 and format as h:mm
>
> =1350/1440 = 0.9375
>
> Formatted as h:mm = 22:30
>
> Biff
>
> "Steved" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>
>

You're welcome!

Biff

"Steved" <[email protected]> wrote in message
news:[email protected]...
> Thanks Biff
>
> "Biff" wrote:
>
>> Divide by 1440 and format as h:mm
>>
>> =1350/1440 = 0.9375
>>
>> Formatted as h:mm = 22:30
>>
>> Biff
>>
>> "Steved" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
>> >
>> >
>>
>>
>>