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.