Calculating Time in Hours and round it up.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top