Calculating Time in Hours and round it up.
 

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.

Calculating Time in Hours and round it up.
 

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
--
Regards

Roger Govier


"newbie" wrote in message
...
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.