asked on

Rounding time

Hi there,

I am not sure if I will explain properly what I need, but here it goes.

I need to make an Excel 2010 formula that will round time (in decimal) to the closest increment.

For example:
Increment=15minutes
10.05h=10.00h
10.20h=10.25
10.45h=10.50
10.99h=11.00

Thanks for your help!

Cheers,
Rene

SOLUTION

helpfinder

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Ejgil Hedegaard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ReneGe

ASKER

Thanks helpfinder for your prompt response :)

Your formula works on your spreadsheet, But not with my numbers.

Here is a list of times that needs to be rounded up:
8.70
12.53
13.02
19.42
20.86
8.93
13.07
13.50
18.48
8.37
12.61
13.05
18.13
8.54
12.50

Thanks and cheers,
Rene

ReneGe

ASKER

Hi hgholt,

Thanks, you nailed it! That's exactly what I need!!

Cheers,
Rene

helpfinder

OK, I see, but can you explain me what time represents 8.70 or 20.86?

Ejgil Hedegaard

8.70 is 8 hours and 0.70*60 = 42 minutes.

ReneGe

ASKER

Hi Helpfinder,

.7 is the decimal value of the minutes.

Maybe I should have not mention the word time in my question. That might have been confusing. Sorry about that :(

8.70

60*.70=42

8h42

Cheers

ReneGe

ASKER

Hi Helpfinder,

I'll give you some points for your efforts and I may actually need to use your formula soon :)

Cheers,
Rene

ReneGe

ASKER

I am very grateful!
Thanks again :)