Excel.

Has anyone any idea how to convert munites to hrs and munites, bar the obvious way :unamused:. I’ve just knocked up a WTD calculator and can’t for the life of me find how to do it, as everything’s in munites at the moment.

I’m actually using a piece of freeware 602 PC Suite, but it’s so close to Microsoft’s Excel, I don’t think it matters.

Cheers

Ian.

Lib,

Why bother?? I was doing the same a while ago and then Krankee posted here.

I binned mine after that as the one from the above link is good!

If you still want the answer to the above question let me know and i’ll read-up to double check before I post duff info!! :confused:

Yeah, but it works over 17 weeks, not 26.

Cheers

Ian.

Spreadsheets don’t like dealing with hours/minutes and do not seem to recognise anything greater than 24 hours. I’ve tried writing a Time calculator that will deduct one time from another, e.g. 1235 from 0110, but it got so big and complicated, I gave up.

The download can handle any number of weeks. Just reset it and then change the number of weeks.

If you use this formula

=INT(A1/60)&" hours “&MOD(A1,60)& " minutes”

In say Cell B1 it would display the number of minutes in A1, say in this case 374 as:

6 hours 14 minutes

You could copy that formula down column B as far as you needed it, changing the A1 to A2, A3, A4 etc as required.

If you then had a column of minutes from say A1 to A12, with the hours and minutes displayed in B1 to B12, You could total column A in A13, =SUM(A1:A12), and in B13 have the above formula as:

=INT(A13/60)&" hours “&MOD(A13,60)& " minutes”

which would give you the total number of minutes displayed as hours and minutes.

If you don’t want the words hours and minutes displayed use this formula instead

=INT(A1/60)&" : "&MOD(A1,60)

The only problem with that is it dispalys the minutes as a single number when they are less than ten. i.e. 248 minutes would display as 4:8 instead of 4:08 where using the formula with the words would show it as 4 hours 8 minutes

I’ve been using this formula in one of my spreadsheets for a while now and it works OK.

Hope that helps a little.

Krankee:
Spreadsheets don’t like dealing with hours/minutes and do not seem to recognise anything greater than 24 hours. I’ve tried writing a Time calculator that will deduct one time from another, e.g. 1235 from 0110, but it got so big and complicated, I gave up.

The download can handle any number of weeks. Just reset it and then change the number of weeks.

Thanks Krankee and Neil, the thing is, I’m learning a bit about excel as well if you see what I mean, but I’ve downloaded the calc to chek my sums :wink:.

I can get it to work for days, but am struggling to get it to work if the finish time is before the start time (i.e. nights), if you see what I mean :confused: :confused: :confused:

Not sure but I think somewhere in the formula you would need to add on 720 minutes (12 hours) to show that the finish time is in advance of the start time.

I’ll have a play around this week and see if I can get it to work. Can you give us an example of what you are trying to do so it is clearer?

I’m playing around a the moment trying to get a formula that will add the two cells if the start time is > then the finish time, at the moment for “days” you only have to do end time - start time to get total hours. (basic example if you can follow it) But playing with it will get me out of having to mow the grass, so I’m not rushing :laughing: :laughing: :laughing:

Ok, have done 2 sheets, one for 26 week and one for 17 weeks, Please feel free to use, Modify or generally play with, both are unlocked, let me know if you spot any errors :laughing: :laughing:

Have just spotted an error in it, total time over 17/26 weeks does not add up - yet - will load newer version as soon as I have time.

Ok, errors now fixed, If anyone finds anymore please let me know :laughing: :laughing:

Sorry links removed for the moment.

smcaul:
Ok, have done 2 sheets, one for 26 week and one for 17 weeks, Please feel free to use, Modify or generally play with, both are unlocked, let me know if you spot any errors :laughing: :laughing: [/url]

Git, that’s a lot better than mine and mine only took me 3 days :unamused:. Thanks SMCaul. It’s answered a lot of questions about the mathematical funtions (I hate maths and was having trouble :wink:).

Mine took all afternoon, must admit to having a bit of a struggle convincing Excel to go past midnight, but got there in the end. Am still playing with the format etc to put it onto a PDA (pocket PC), but at least in that version you can see the formula’s and how it works.

This is a problem which is pre computer (and calculator). I used to be at sea and we had to do lots of sums involving hours minutes (and seconds). The way to do it is to decimalise the hours. 6 minutes is point one of an hour - so you can do it in your head. i.e. 7 hours 35 minutes is 7.583 hours or 7.6 hours for cash. It works well if things happen every six minutes.