Rounding time in .25 increments

[merkaba22]

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!

[Brian C]

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) , ":" , "

[comment]

Try

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

[merkaba22]

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?

[comment]

Further ideas to do what?

[merkaba22]

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

[ralph.nusser]

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)