Home

Welcome to OnlineConversion.com

minutes to hours and minutes
 

minutes to hours and minutes
by alina on 12/18/04 at 15:53:38

How can i 'automate' calculating hours and minutes from minutes ?

For example: 135 minutes is 2 hours and 15 minutes.

What formula (ideally in a spreadsheet) could I use?

Big thanks,
alina


Re: minutes to hours and minutes
by alina on 12/18/04 at 16:08:51

Just to add - I do realise that modulo 60 could come into it, just haven't got a clue how to achieve it in Excell or KSpread or OpenOffice, etc.

Thanks,
alina


Re: minutes to hours and minutes
by Robert Fogt on 12/19/04 at 01:50:42

I created the following formula in Microsoft Excel 2003.

Assuming cell A1 contains the total number of minutes, and I installed the formula in cell A2:

=FLOOR(A1/60,1) & " hours" & MOD(A1,60) & " minutes"

So if cell A1 contained 135, then the formula displays:
2 hours 15 minutes


Re: minutes to hours and minutes
by Alina Swietochowska on 12/19/04 at 16:24:21

Thanks for that - it works.

I have since found out that CONCATENATE function can be used as well.

CONCATENATE(INT(A1/60),":",MOD(A1,60))
would give 2:15

Once again big thanks,
alina




Go Back | Archive Index


 

Did you find us useful?

Please consider supporting the site with a small donation.

click here for more information

 


BookMark Us

It may come in handy.

Check out our Conversion Software for Windows.

Can't find something?
Try searching.

Are you bored?
Try the Fun Stuff.

Was this site helpful?
Link to Us | Donate