ExcelBanter - Data calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data calculation (https://www.excelbanter.com/excel-discussion-misc-queries/210730-data-calculation.html)

Data calculation

I have 2 cells (f4 & g4) , with format in hh:mm. When use a formala f4-g4
in
a 3rd cell it gives me the difference of hrs between the 2 cells. But If I
want to apply some calculation on the 3rd cell it does not work.
Example f4 - g4 gives me 13:00 and in cell h4 my formula is (f4-g4)*2. The
answer I get is 2:00. I want the answer 26:00.
Can you please advise, How can I do this.

Thanks

Peo Sjoblom[_2_]

Data calculation

Format as [h]:mm

--

Regards,

Peo Sjoblom

"ub" wrote in message
...
I have 2 cells (f4 & g4) , with format in hh:mm. When use a formala f4-g4
in
a 3rd cell it gives me the difference of hrs between the 2 cells. But If
I
want to apply some calculation on the 3rd cell it does not work.
Example f4 - g4 gives me 13:00 and in cell h4 my formula is (f4-g4)*2.
The
answer I get is 2:00. I want the answer 26:00.
Can you please advise, How can I do this.

Thanks

John C[_2_]

Data calculation

It is because it is over 1 day, format the cell as [hh]:mm
--
** John C **

"ub" wrote:

I have 2 cells (f4 & g4) , with format in hh:mm. When use a formala f4-g4
in
a 3rd cell it gives me the difference of hrs between the 2 cells. But If I
want to apply some calculation on the 3rd cell it does not work.
Example f4 - g4 gives me 13:00 and in cell h4 my formula is (f4-g4)*2. The
answer I get is 2:00. I want the answer 26:00.
Can you please advise, How can I do this.

Thanks

All times are GMT +1. The time now is 08:51 PM.