# Rounding time in .25 increments

This topic is 7074 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

Hi again!

Did a search for this one but haven't found it.

I have a calc where end_time - start_time = total_time. This is fine but I would like to further refine this time in 1/4 hour increments. Ie, 1:38 = 1.5 or 1:45 = 1.75, etc.

This must be the type of thing that comes up often but I really don' really know how to go about creating it. Any help would be greatly appreciated.

Thanks once again!

##### Share on other sites

Actually its not too difficult to do:

Change your calculation field to have the result display as a number or text (whichever is your preference) and use the following calculation:

LeftWords(Substitute(TimeToText(end_time - start_time) , ":" , "

##### Share on other sites

Try

Round ( ( end_time - start_time ) / 900 , 0 ) * 0.25

##### Share on other sites

I appreciate both of your offerings -- thank you.

Brian C -- yours seemed to convert to the % of an hour

Comment -- yours worked great.

I guess I should have realized that I would really need this to round in a particular way. For example, anything between say 8-22 minutes would be .25, 23 to 37 minutes would be .50, 38-52 would be .75 and 53-60 would trip over to 1 hour.

At least that's how I would want my work to be counted -- wouldn't that be typical protocol, I'm not sure....

Any further ideas?

##### Share on other sites

Further ideas to do what?

##### Share on other sites

I guess it was late last night when I check this out because now it works like I need -- thank you:)

##### Share on other sites

When the result has to be [color:"red"] Time and not text or number the calculation is:

Round((Time End-Time Start)/900; 0) * 900

e.g.: Time Start: 00:37:14; Time End: 15:20:00 => Result: 14:45:00 (14 hours and 45 minutes)

##### Share on other sites

This topic is 7074 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account

×
×
• Create New...