Rounding time in excel (2003)

A

Alan

I want to get a formula to round time up to the nearest 15 minutes. The
challenge is that the field I need to analyze is in a decimal form.
Example: In A1 is the value 2.20
I want an equation in B1 that results in the answer 2.25, or 2 and a
1/4 hours.

Can anyone help?

TIA, Alan
 
D

David Welch

Alan said:
I want to get a formula to round time up to the nearest 15 minutes. The
challenge is that the field I need to analyze is in a decimal form.
Example: In A1 is the value 2.20
I want an equation in B1 that results in the answer 2.25, or 2 and a
1/4 hours.

Can anyone help?

TIA, Alan
Click to expand...

I think this should work:
=TIME(ROUND(YourCell,0), ROUND(MINUTE(YourCell/24)/15,0)*15,0)
 

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

rounding help 6
advice on rounding or ceilng a 24 hour time value 3
Round time to nearest 15 minutes in decimal format 4
include rounding in a formula 2
Rounding time 2
Converting time to decimal then rounding 2
Rounding in Excel 3
rounding decimal places 4

Top