Calculating Time in Hours and round it up.

N

newbie

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.
 
R

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pieces picked per hour 0
Calculate end date and time 1
Word 2016 - Difficulties Learning Style Creation/Application 0
Calculate After hours 3
Rounding down and displaying as a fraction 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Showing 24 hour time along X-axis 0
Format for Time Elapsed in Decimal 4

Top