Minutes to hours

[tyger]

Hi

I'm pretty new to the excel scene, so forgive my lack of terminology knowledge

I've calculated a list of results which give me the length of time to do a bunch of tasks. The results I get are in minutes. Starting from 0.40 minutes, to 0.80 minutes (1 hours and 20 minutes), all the way up to 164.80 minutes.

I need to be able to turn those "minutes" into hours. How can I calculate this?

For instance, I know 2.80mins is actually 4hours and 20mins.

But whats the equation?

[daddylonglegs]

wouldn't 2.80 represent 4:40?

If so then to convert 2.80 in A1 to a time value 4:40 try this formula in B1

=A1*100/1440

format B1 as [h]:mm

[MickG]

Hi, If I could just add to the post of "Daddylonglegs" :-
If you make a custom format of dd:hh:mm you will then cater for the days as well.
Regards Mick

[tyger]

Yay, it worked effortlessly. Thank you Daddylonglegs.

I also took your advice and put in the days too. Thanks MickG

[daddylonglegs]

dd:hh:mm

You just have to be a little careful with that formatting because it won't correctly show periods of 32 days or more. If your maximum value is 164.80, as you say, then that won't be a problem because it only equates to 11 days but should you have longer periods you might want to stick with the total hours or use this formula to display days, hours and minutes as a text string

=INT(A1*100/1440)&" days "&TEXT(A1*100/1440,"hh:mm")

[tyger]

This adapted equation seems to give me completly different results. Little over double the original amount of time. Deviding by 2 still has an different result.

In addition, I'd like to ask one more thing which is bugging me a little. Is there an "if" statment I could include to add an extra 7 hours after every 12 hours have passed?

Project: I'm trying to calculate the amount of hours it would take to hike an x amount of miles, with 7 hours rest after 12 hours of hiking.

[daddylonglegs]

This adapted equation seems to give me completly different results. Little over double the original amount of time. Deviding by 2 still has an different result

Can you give an example. Both formulas return the same result for me, except for large values of A1 where, as I said, the first formula won't display the correct amount if periods of 32 days or more are format as dd:hh:mm

In addition, I'd like to ask one more thing which is bugging me a little. Is there an "if" statment I could include to add an extra 7 hours after every 12 hours have passed

I'm sure that could be done....are you referring to adding time to a single figure, e.g. 36 hours has to have 21 hours added....or do you want to add to a range of values.

If it's the former and you have the time in A1 in your original format, e.g. 23.80 represnting 2380 minutes then you could convert this into hours and add 7 for every full 12 hours....

=INT(A1/14.4+INT(A1/7.2)*7/24)&" days "&TEXT(A1/14.4+INT(A1/7.2)*7/24,"hh:mm")