Converting Minutes into Hours and Minutes using a Formula

• Can anybody please assist me with creating a formula for converting time data that has been created in an excel spreadsheet in minutes i.e. 516 minutes which I need to turn into Hours and Minutes i.e. 08:36
I am not experienced using Formulas, apologies if this question has been posted before, I did use the search facility to look for threads, but could not find anything related

Many Thanks

Gingie Cat

• Re: Converting Minutes into Hours and Minutes using a Formula

For total minutes less than 1440 you can use excel's built in TIME function.

=TIME(0,minutes,0) will convert your minutes into a decimal time serial number. You can either format this to show the hours and minutes, or reference the cell with =hour(cell) and =minute(cell)

If the total minutes is more than 1440, you need to work out the number of days. You can use the MOD function like so: =MOD(minutes,1440).

This gives you the number of days, so if you need the answer in hours you will need to multiply by 24.

--
I'm not getting you down am I?

• Re: Converting Minutes into Hours and Minutes using a Formula

Hi Gingie Cat,

Welcome to the OzGrid forum.

If you don't mind your answer being in text format, you can use the following:

=TEXT(FLOOR(A1/60,1),"00")&":"&TEXT(MOD(A1,60),"00")

Hope this helps.

[COLOR="Purple"]Regards,[/COLOR]
[COLOR="Purple"]Batman.[/COLOR]

• Re: Converting Minutes into Hours and Minutes using a Formula

If your minutes are in A1 try this. Format cell as time
[vba]=A1/24/60[/vba]

[h4]Cheers
Andy
[/h4]

• Re: Converting Minutes into Hours and Minutes using a Formula

Thank you all for such a quick response. The answers you have given have resolved this for me
Great Forum !!!

Gingie Cat

• Re: Converting Minutes into Hours and Minutes using a Formula

Hey, i had the same situation with vb.net. You can paste below code in your module and use it as and when you want

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!