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