time calculation

[Raymond]

If cell A1 contains the time 6 AM and cell B2 contains the time 9 Am, how do
I calculate the difference of time between two and return a value of 3 hour,
then adding this 3 hours to other hours?

Thanks

 

[martialtiger]

Raymond,

What you want to do is make sure that the 3 cells that will contain th
time is formatted correctly. To do this just right click on the 3 cell
and then select Format. Then you want to select Number and find th
Time selection. Finally choose the one with the "1:30 PM" example.
Now for the cell where you want the display to show the number o
hours, right click on the cell and select Format as well. This time g
to custom and type in hh:mm as the format.

Good luck

 

[Rob]

Hi Raymond,

You can do it by typing in the formula in Cell C1, =B2-A1 (format both these
cells as Time 1:30PM).
This will give 3:00 as the answer (format this cell as Time 13:30).

Then in Cell D1 you could have, = C1+B2 (format this cell as Time 1:30PM).
This will give the answer in C1 as 12:00 PM

Or, you could combine the formulas and have instead in C1, =B2-A1+B2 and
ignore D1(format this cell as Time 1:30PM) .

You must enter the times in A1 and B2 leaving a space between the time and
AM or PM!

Hope that's what you're after.

Rob

 

[Raymond]

What if I want the return value to be 3, a number instead of 3:00 because if
you take 3:00 * number, which is what I want, then the answer will be
wrong..

Thanks

 

[Frank Kabel]

Hi
multiply the result with 24 and format the cell as number