Rounding time values to nearest 15 minute and convert to decimal

  • Thread starter Thread starter Jeff Muniz
  • Start date Start date
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)
 
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.
 
Back
Top