Calculating Time in Hours and round it up.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newbie - 11 Jul 2007 11:42 GMT

Hi,

In A1, I type in 0001 and in A2, I type in 0700 (both cell in Text format)

In A3, I like it to display the hours in between 0001hrs to 07000hrs in
Hours rounding it up to 7 hours instead of 699. How to I make it happen?

Thank you.

Reply to this Message

Roger Govier - 11 Jul 2007 12:50 GMT

Hi

Try
=CEILING(A2-A1,100)/2400

The ceiling part rounds it to 700. Divide that by 100 to give 7, then
divide that by 24, (i have combined that to divide by 2400)as Excel
stores times as fractions of a day.
Format the cell as hh:mm

Signature

Regards

Roger Govier

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message