Thread: Formula help needed

Hi, I'm a complete novice when it comes to Formulae but I have found some help on the formula's listed on this site. However I can't find what I need to complete, I'm sure it's very simple. This is what I've got:-

2 columns (H & G) with times shown as hh:mm:- 14:06 & 14:51 and these times are subtracted as below

=H355-G355 +IF(A2>B2,1)

The above formula is in column I - gives the answer as 00:45

I need to multiply the result by 17 but it doesn't seem to work.

The result of the above formula in column I for example is 00:45, if I then ask to multiply this cells figure by 17 - i.e I355*17 I get a result showing "1" when really 45 mins multiplied by 17 would be 7.65

Can anyone help me out here?

Please check the cell format.

Actually, the result should 12:45 not 7.65.

Originally Posted by Tanglefoot

Hi, I'm a complete novice when it comes to Formulae but I have found some help on the formula's listed on this site. However I can't find what I need to complete, I'm sure it's very simple. This is what I've got:-

2 columns (H & G) with times shown as hh:mm:- 14:06 & 14:51 and these times are subtracted as below

=H355-G355 +IF(A2>B2,1)

The above formula is in column I - gives the answer as 00:45

I need to multiply the result by 17 but it doesn't seem to work.

The result of the above formula in column I for example is 00:45, if I then ask to multiply this cells figure by 17 - i.e I355*17 I get a result showing "1" when really 45 mins multiplied by 17 would be 7.65

Can anyone help me out here?

If you want to extract the number of minutes from a time difference, use =(H355-G355)*1440 with the answer cell formatted to General or Number, then answer * 17 will equal 765

hth
---

Originally Posted by Tanglefoot

Sorry I should have said the calculation I'm trying to do is 45 mins X 17

If you multiple three-quarters of an hour by 17 you will get twelve and three quarter hours as your answer.

meters - i.e. production.

I need the time to show as 00:45 and the meterage as 7.65

. . so why not, as was suggested, show your time as hours and minutes and convert to minutes to do your calculation then divide by 100 to give some unknown ('meterage'?) expression.

Thanks for the suggestions so far but can anyone add to this to help me impress my boss!

Impressing your boss is really not what I am about,


however you can try

=A3*1440*17/100

where A3 is the difference in time between A1 and A2 (ie,00:45) for an answr of 7.65.

---

Originally Posted by Bryan Hessey

Impressing your boss is really not what I am about,

Sorry I was only trying to be a little light hearted. It's no big deal. My boss probably couldn't care less and neither could I in all honesty.


=A3*1440*17/100

where A3 is the difference in time between A1 and A2 (ie,00:45) for an answr of 7.65.

Thanks for the above suggestion all the same.

Originally Posted by Tanglefoot

=A3*1440*17/100

where A3 is the difference in time between A1 and A2 (ie,00:45) for an answer of 7.65.

Thanks for the above suggestion

Good to see it worked for you, and thanks for the response.

---