calculating times in 15 minute increments

Thanks so much for trying to help!!

I need to calculate leave taken by an employee in 15 minute intervals.

For example:

1.15 hours of vacation (one hour and fifteen minutes)

+2.30 hours of holiday leave (two hours and thirty minutes)

+ 4.45 hours of sick leave (four hours and forty-five minutes)

= 8.30 hours of total leave taken (eight hours and thirty minutes)

Anything I try has calculated it as:

1.25

2.50

4.75

=8.50

I have to have it formatted in 15 minute increments instead of decimals

Any ideas?

Gene-O

as far as the colon and decimal this can be done under patterns

example

num{zzzz9:99}

but could you give a little more detail Im a little hazy on what your trying to do

The easiest thing may be to break it into 2 fields or three if days

___days   ____hours  ____min

this way you can manipulate the data a little easier depending on your requirements

Sorry if Im no help still a little hazzy on what yoru trying to do as far as summing

are you going to chang the .15 to a .25 for your calculations ?? and then translate them back to 15 min incriments etc....