Rounding time values to nearest 15 minute and convert to decimal

J

Jeff Muniz

Using Excel 97:

Cell B2 has a starting time (09:22)
Cell B3 has an ending time (11:51)

I want Cell B4 to calculate difference (2:29)(I got this part) round to
nearest 15 minute (2:30) then convert to a decimal time (2.50)
 
J

J.E. McGimpsey

You can do that all in one step:

B4: =ROUND((B3-B2)*4*24,0)/4

or, more succinctly:

B4: =ROUND((B3-B2)*96,0)/4

XL stores times as fractional days (e.g., 6:00 =0.25), so you need
to multiply by 24 to get decimal hours.
 

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

Top