Data Calculation

U

ub

Hi

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
 
T

Tom [Pepper] Willett

Try an Excel newsgroup. This is FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: Hi
:
: 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to color cells based upon a value in another cell 1
Data calculation 2
Combining two functions 13
Returning last number(time) in a row of cells 4
Conditional formatting for time 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Leave final cell blank 2
how to copy paste the figures in adjoining cells? 0

Top